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.
Answers
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67K Get Help
- 442 Global Discussions
- 154 Industry Talk
- 503 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 79 Community Job Board
- 512 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!