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

Matt Foss

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.

Paul Newcome

Try something like this...

=IF(Evaluation@row = "Yes"m "Evaluation in Progress", IF(Meeting@row = "Yes", "Meeting Scheduled", IF(Assessment@row = "Yes", "Assessment")))

Paul Newcome

Try something like this...

=IF(Evaluation@row = "Yes"m "Evaluation in Progress", IF(Meeting@row = "Yes", "Meeting Scheduled", IF(Assessment@row = "Yes", "Assessment")))

Matt Foss

Thanks Paul! That did the trick, it was my original formula but I was missing a column that caused some logical issues in the layout. I believe I found the solution, thanks for your help!

Paul Newcome

Happy to help. 👍️

Matt Foss

Appreciate it @Paul Newcome! Actually, I further realized the issue was the ordering of my IF statements, so your explanation was even more helpful than I initially had thought.