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

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    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! 😊


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!