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.


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
    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.


    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!