Formula with multiple IFS?

I'm not exactly sure which is the best way to go about this but my brain is fried so i'll try explain the simplest way.

Example:

Column 1 - checkboxes

Column 2 - list of values (2022, 2023, 2024, 2025). multiple values can be selected

Column 3 - Red, Yellow, Green Symbols

I want column 3 to have a green circle if column 1 is checked OR column 2 contains the value "2024". Even if column 2 had 2022, 2023, and 2024, I still want it to be green because "2024" is included in the cell.

Find more posts tagged with

Accepted answers

All comments

Kaveri Vipat

Hi Nana250,

You can try the formula in column 3 as per your condition-

=IF(OR(Checkbox@row = 1, CONTAINS("2024", Year@row)), "Green", " ")

I hope this works for you.

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.