Flag By Issue Status Formlua

Actual Goodfella
Actual Goodfella ✭✭✭
edited 12/09/19 in Formulas and Functions

This seems so basic, but I cant get this formula to work. I have a flag colum that I want the flag to be 'flagged' if the Issue status column has an issue listed as "Open"

This is what I'm using and getting an unparseable 

=IF(Issue@row = Open, 1,0)

Thanks in advance!

 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!