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
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!