Formula with multiple IFS?

Options

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.

Answers

  • Kaveri Vipat
    Kaveri Vipat ✭✭✭✭✭✭
    Options

    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.

    Thanks,

    Kaveri Vipat

    Senior Associate - Smartsheet Development, Ignatiuz Software

    2023 Core Product Certified

    Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!