How to auto-trigger a flag in smartsheet?

Emi ✭✭
edited 01/25/22 in Formulas and Functions

Hi All,

I am relatively new to smartsheet and trying to see if I can auto-trigger a flag in smartsheet?

For example, if the quantity is under 500, the flag will automatically turn red. Is there a formula or a way to do this? Another question, if the quantity wasn't in the same sheet that the flag was at, can I still trigger the flag by linking to another sheet cell?

Thank you

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!