How can I set up a formula with the star symbol if 6 different conditions are met?
I am trying to set up a formula that looks at 6 conditions and if met, the star will light up. I don't know where to begin. Right now I have
=IF(AND([BG Results]@row = "PROCEED", [Poly]@row = "PASS", [Chief Approval]@row = "YES",[Drug]@row = "PASS",[Medical]@row = "PASS", [Psych]@row = "PASS"), 1,0))))))
Answers
-
=IF(AND([BG Results]@row = "PROCEED", [Poly]@row = "PASS", [Chief Approval]@row = "YES",[Drug]@row = "PASS",[Medical]@row = "PASS", [Psych]@row = "PASS"), 1,0)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.1K Get Help
- 444 Global Discussions
- 142 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 83 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!