Trying to trigger a flag to turn red once the project status column has changed

Have a Flag column named Outstanding Balance. I would like to have the flag trigger red if the project status column (which is a drop down) is changed to Invoiced or partial payment received.

I have tried various formulas, but it keeps coming up with #unparseable.

Any help would be appreciated.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!