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.

Find more posts tagged with

Formulas

Accepted answers

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")))

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.