IF Statement to return a Flag Symbol

Erica Anderson

Hello!

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!

https://help.smartsheet.com/articles/2480316-available-symbols-in-symbols-column?_ga=2.268069645.2025226213.1586144164-26677896.1584028679&_gac=1.220523948.1586453499.EAIaIQobChMIgoum4O_b6AIVDuDICh170QQMEAAYAiAAEgKWRvD_BwE

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

Andrée Starå

Hi Erica,

It’s because you’re using "0" and ”1” so it’s treated as text.

Try this.

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

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi Erica,

It’s because you’re using "0" and ”1” so it’s treated as text.

Try this.

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

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Erica Anderson

Thank you so much Andree! That worked, I really appreciate your assistance!

Andrée Starå

Excellent!

Happy to help!