Formula with multiple IFS?

Nana250

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.

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.