How can I set up a formula with the star symbol if 6 different conditions are met?

Options

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!