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
Check out the Formula Handbook template!