Forum Discussion

ClariceDennison's avatar
ClariceDennison
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
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
Try this

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

//I'm assuming that the Completion Date is a Date field type and the other field is a Date / Time field type.



------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
  • ClariceDennison's avatar
    ClariceDennison
    Qrew Trainee
    4 years ago
    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's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew 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
      ------------------------------