How to display the value of column A once a value is found on column B?
I'm new on smartsheet and I'm having difficult to find (or express myself the correct way) articles that are displaying what I need. So I need your help.
I do have a master sheet with several pieces of information. On a Column A I do have customers names. Column B I do have a multiselection cell where these customers have informed events they would be participating.
What I do need to make it happen is:
Once a customer have selected Xmas on Column B on my original sheet, another sheet would pull the name of the customer found on Column A from the original sheet to display it on my second sheet.
Is there an easy way to make it happen?
Thanks in advance.
Help Article Resources
Check out the Formula Handbook template!