need pls. advise for formula
Hi, pls. see pic. below: I'm looking formula that will light in green column called greenlight to install , when all other columns are checked and red when at least 1 column is unchecked
Thanks in advance
Yuval
Best Answers
-
Hi Yuval,
You can try this formula for your condition-
=IF(AND([Materials in Rigotec/Talad]@row = true, [Materials in CR]@row = true, [HC in Place]@row = true, [QA/QC done before install]@row = true), "Green", IF(AND([Materials in Rigotec/Talad]@row = false, [Materials in CR]@row = false, [HC in Place]@row = false, [QA/QC done before install]@row = false), "", IF(OR([Materials in Rigotec/Talad]@row = false, [Materials in CR]@row = false, [HC in Place]@row = false, [QA/QC done before install]@row = false), "Red")))
Hope this will work 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⬆️"
-
Cool, many thanks Kaveri, working as watch, just copy and paste, perfect
Yuval
Answers
-
Hi Yuval,
You can try this formula for your condition-
=IF(AND([Materials in Rigotec/Talad]@row = true, [Materials in CR]@row = true, [HC in Place]@row = true, [QA/QC done before install]@row = true), "Green", IF(AND([Materials in Rigotec/Talad]@row = false, [Materials in CR]@row = false, [HC in Place]@row = false, [QA/QC done before install]@row = false), "", IF(OR([Materials in Rigotec/Talad]@row = false, [Materials in CR]@row = false, [HC in Place]@row = false, [QA/QC done before install]@row = false), "Red")))
Hope this will work 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⬆️"
-
Cool, many thanks Kaveri, working as watch, just copy and paste, perfect
Yuval
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!