IF Statement to return a Flag Symbol

Erica Anderson
edited 04/15/20 in Formulas and Functions


I've got an IF Statement created to leave the at risk flag blank if the "done" box is checked, and make the flag red if the due date is within 5 days of today. I can tell it's working because it's populating at "1" but it should be populating a flag symbol?

I've checked this article, and attempted to replace the 1 with the word flag, and the end result is exactly the "1" or word "flag" versus a symbol, help!


=IF(Done@row = 1, "0", IF(Due@row <= TODAY(+3), "1"))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!