Flag Column

Hello!

I'm trying to trigger the flag in the overdue column if we've missed the proposed response date. My formula is calculating, but it's not turning the flag on. What am I doing wrong?

=IF([PROPOSED RESPONSE DATE]2 < TODAY(), "1")


Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!