How would I return a specific status based on differences in multiple other cell columns?

I am attempting to create an automatic status update that is driven by different options selected in multiple other cell columns. For example:

I want my Status column to indicate "Assessment" if another column regarding the assessment is marked as "Yes". However, if another column regarding a meeting is marked as "Yes," I want my status column to indicate "Meeting Scheduled." Finally, if another column regarding an evaluation is marked as "Yes," I want my status column to indicate "Evaluation in Progress". Note that the other columns will only say Yes when that step has occurred, otherwise it remains blank.

I have attempted an IF statement but it seems to be stuck as binary. I suspect I need to use AND or the OR addition, but I'm having trouble and most other questions about this seem to be only related to updating a status based on multiple variables within only one other column.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!