OMG THANK YOU for this! I knew there had to be a way to do this, but couldn't find anywhere that explained it clearly enough for me to setup without getting error outputs. This is going to save me HOURS of work each day!
I just found your account and your videos are a heaven-sent. Can you do a video on the ‘join-collect’ formula in smart sheets to pull multiple data points into one cell. 🙏
Nicely explained, only when you pulled down the formula in the first sheet, the match range reference became incorrect: row 1 to 8 became 2 to 9, then 3 to 10. I guess there is something like $ in Excel to fix the range.
Great video! I’ve been looking for this info for days. Thanks for posting. The only issue I’m still having is that my match criteria will potentially be repeated across multiple rows and it will only pull the first entry. If we apply it to your example ‘Clara’ would be overseeing ‘Implementation A, D, & G’ but when I use this formula it only pulls the information for ‘Implementation A’. But I need ‘Implementation D & G’ pulled over as well. Do you know how I might be able to fix this?
👍 Thank you so much, it is very interesting video, but how can we search a value with different criteria, for example if the project manager name is in different lines? For example we search the name of the "Project Manager" who works the "Product A" and who started the project in February. In Excel, it is with INDEX and MATCH combinaison with Shift+Enter cell validation, but not in SmartSheet. Thank you again for this video
Get my Smartsheet Formula training course: properprojectmanagementtraining.teachable.com/p/smartsheet-formula-training-course
OMG THANK YOU for this! I knew there had to be a way to do this, but couldn't find anywhere that explained it clearly enough for me to setup without getting error outputs. This is going to save me HOURS of work each day!
You're very welcome!
I just found your account and your videos are a heaven-sent. Can you do a video on the ‘join-collect’ formula in smart sheets to pull multiple data points into one cell. 🙏
Excellent, pleased to heat it. I will add it to my "to record" list for sure! Look out for it!
Very good video, you took something complicated and expalined it in an easy to understand method. Thank you so much!
Excellent to hear it, Justin. Thanks for the kind words too my friend.
Nicely explained, only when you pulled down the formula in the first sheet, the match range reference became incorrect: row 1 to 8 became 2 to 9, then 3 to 10. I guess there is something like $ in Excel to fix the range.
Good spot. Correct. You can 'lock' the range as you do in Excel.
Great video! I’ve been looking for this info for days. Thanks for posting. The only issue I’m still having is that my match criteria will potentially be repeated across multiple rows and it will only pull the first entry. If we apply it to your example ‘Clara’ would be overseeing ‘Implementation A, D, & G’ but when I use this formula it only pulls the information for ‘Implementation A’. But I need ‘Implementation D & G’ pulled over as well. Do you know how I might be able to fix this?
This is my issue as well! Any chance you've found a solution/heard back?
@@marypham2 no not yet! Still on the hunt
Thank you. I will have a look around and get back to you if I find anything!
THANK YOU! This helped me so much.
I'm so glad! Thank you
Super duper helpful and exactly what I needed. Thanks!
Great to hear! Thanks Audrey!
Thanks for your guides. But, in cases, the Project Manager's name Jason was showed twice in one column, how do we deal with it?
I'd suggest making sure the surname is included too.
omg life saver thank you!
👍 Thank you so much, it is very interesting video, but how can we search a value with different criteria, for example if the project manager name is in different lines? For example we search the name of the "Project Manager" who works the "Product A" and who started the project in February. In Excel, it is with INDEX and MATCH combinaison with Shift+Enter cell validation, but not in SmartSheet.
Thank you again for this video
Hello Guillaume. Perhaps this will be of help: community.smartsheet.com/discussion/69141/can-you-use-2-match-criterias-in-an-index-match-formula
incredible
I am trying to combine 5 text boxes into one, is that possible?
Have you tried the concatenate formula?
Very good video!
Thanks Miguel! Pleased to hear it was useful.
Many thanks to you
Thanks Karim!