Flag Column

Wendy Young

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")

Paul Newcome

Try Removing the quotes from around the "1".

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

Wendy Young

Okay, I figured out the flag part. However, now it's immediately flagging if a date hasn't been entered yet. Here's the formula that I'm using. . .

=IF(TODAY() > [PROPOSED RESPONSE DATE]@row, 1, 0)

Please help! Thank you!!!

Paul Newcome

That's because blank date fields are considered less than any entered date (nothing is less than something kind of thing). We can use an AND statement to include the criteria of it being an actual date.

=IF(AND(ISDATE([PROPOSED RESPONSE DATE]@row), TODAY() > [PROPOSED RESPONSE DATE]@row), 1, 0)

Wendy Young

Perfect! Thank you!!

Paul Newcome

Happy to help! 👍️