Help with multiple OR criteria to return data from 1 of 4 cells to another cell

Dpres

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.

SmartSheet Question.PNG

Nick Korna

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

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! 😊

Dpres

@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

Dpres

@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!

Nick Korna

Happy to have helped! 😊