Forum Discussion

CiaraHarris's avatar
CiaraHarris
Qrew Member
5 years ago

Formula to highlight records on a report that have been modified/updated in the last 7 days

I have a running progress report to display request updates, but want to highlight the requests that have been updated in the last 7 days using color coding.

------------------------------
Ciara Harris
------------------------------
Formulas and functions
reports and charts
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    Hi Ciara, (just got off a call w/ Elise)

    np

    Use a formula like this to do row colourization on a table report.

    IF(ToDate([Date Modified]) >= Today() - Days (7), "yellow")



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • CiaraHarris's avatar
      CiaraHarris
      Qrew Member
      5 years ago
      The Best - thanks so much, Mark!!

      ------------------------------
      Ciara Harris
      ------------------------------