Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Flag By Issue Status Formlua

✭✭✭
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!

Trending in Formulas and Functions