Help with multiple OR criteria to return data from 1 of 4 cells to another cell
I have 4 options (logic added to them) for members to select where they work but need their specific clinic to be added to one main Clinic column and am looking for the best formula to have it automatically update to the column. If the Market equals one of the 4 area clinics then it return the correct clinic name for their market area. See the attached snip.
Best Answer
-
Hi @Dpres
If the staff are only working at an option in 1 column at a time you can do this with a simple JOIN:
=JOIN([Austin Clinics]@row:[Rio Grande Clinics]@row)
This will combine all of the columns, but as 3 are blank it will just show the 1 they are at.
If this isn't the case or I've missed something then let me know and we'll see if we can puzzle an alternative out! 😊
Answers
-
Hi @Dpres
If the staff are only working at an option in 1 column at a time you can do this with a simple JOIN:
=JOIN([Austin Clinics]@row:[Rio Grande Clinics]@row)
This will combine all of the columns, but as 3 are blank it will just show the 1 they are at.
If this isn't the case or I've missed something then let me know and we'll see if we can puzzle an alternative out! 😊
-
@Nick Korna thanks, It came back as #UNPARSEABLE but yes, that is what I am looking to do and they will only be at one of the 4 clinics
-
@Nick Korna I got it, I did not put the actual row in and that fixed it. I am really new to smartsheet (but not excel) so this is great!
-
Happy to have helped! 😊
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!