Forum Discussion

Qrew Trainee

4 years ago

If Date Field is Null Turn Row Red

Hi, I have a report where I would like a row to turn red if the task has not been completed within 7 days of the assigned date. However, I am receiving an error. Any suggestions will be greatly app...

Formulas and functions

reports and charts

ClariceDennison

Qrew Trainee

Thank you so much Mark!

re: the date assumption, yes, that is correct.

I ended up switching the formula around as the rows were not turning red.

IF(

IsNull([Completion Date])

and

Today() - ToDate([Assignment Date and Time]) >= Days(7), "#F60612")

Thanks again!

------------------------------
Clarice Dennison
------------------------------

MarkShnier__You

Qrew Legend

4 years ago

OK great, I thought that you wanted to warn when the Today was coming up to be within 7 Days of the Assignment Date but I see that you want to know if it's more than 7 days late.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------