Forum Discussion

MikeSanders's avatar
MikeSanders
Qrew Member
3 years ago

Colors

Help please.  How do i put this into a formula:
If a duration field is > 3 days and a date field is empty then color the row blue.
Any help would be appreciated!

------------------------------
Mike S
------------------------------
Formulas and functions
reports and charts

2 Replies

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    try this

    IF([My duration field]> Days(3) and IsNull([my date field]), "blue")

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • MikeSanders's avatar
      MikeSanders
      Qrew Member
      3 years ago
      Perfect, thank you!

      ------------------------------
      Mike Sanders
      ------------------------------