IF Formula using date cells with formulas

Yazmin Alfaro

Hi,

Im new in smartsheet and im currently trying to compare a Task Limit Date (for completion) with Today's date to determine if the Task is Late or On track

My formula is the following:

=IF(Limitdate@row > TODAY(), "Late", "On Track")

As my Task Limit Date was initially documented in quarters of every year, for example; Q1 2020, Q2 2020 etc., I created a table in another sheet to link with a VLOOKUP formula the quarter dates to their calendar dates, for example, Q1 2020 = 31-mar-2020, this to be able to compare it with the TODAY formula.

For some reason the IF formula is not working given the VLOOKUP formula in my Limitdate cell and im getting an #INVALID OPERATION error. I tried the same formula with a cell with an actual date(no formulas) and it worked.

Any suggestions on how to solve this?

Thank you!

Yazmin

John Jonassen

I've been finding that the Today() function doesn't like to be second place. This formula worked:

=IF(TODAY() > LimitDate@row, "Late", "On Track")