Forum Discussion

BretOsborne's avatar
BretOsborne
Qrew Member
3 years ago

Color Coding Dates

I am newer to QB, but have found formulas to be a challenge so far.

I am trying to do simple color coding for dates, for example i have 4 columns of dates, that will be populated through the project. As each progression of the project is complete i would like to have that date color coded to show the "stage".

so column A,B,C,D, then i will select colors for each column. If no dates are populated, then it would not be color coded. I believe this should be some type of IF statement, but not sure how to formulate it. Thank you for your help!



------------------------------
Bret Osborne
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    If you are looking to colour code individual cells as opposed to rose on a table report then it is not quite as easy as conditional formatting is, in excel. You need to create a new Rich Text formula field.
    https://helpv2.quickbase.com/hc/en-us/articles/4570255561108-Color-coding-fields

    When you do this however that field will no longer be a date field and you will not be able to use dynamic filters as easily.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • BretOsborne's avatar
      BretOsborne
      Qrew Member
      3 years ago
      no, i am not looking to color individual cells, the whole row is fine. I just can't figure out what the formula should be to make this happen.

      so something like this:

      if to QC "date populate" = yellow
      if returned from QC "date populate" = blue
      if to QC 2 "date populate" = green
      If returned from QC 2nd "date populated = Red

      something like that?

      I had 

      If(
      [To QC 1]<(Today()+Days(1)), "yellow",
      [Returned QC 1]>(Today()+Days(1)), "blue")

      but when i got to the second line, is does not read the 2nd next statement.
      I also tried

      If( not IsNull([To QC 1]),"yellow",
      If( not IsNull([returned QC 1]),"blue"))


      but it only reads the "TO QC 1" statement, ignoring the first line.

      I know i am likely missing something basic, but again newbie! :)



      ------------------------------
      Bret Osborne
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        3 years ago
        This format will work, just keep adding conditions like that.  But it will return the first condition which is true, so think about he order of the steps in your IF

        IF(
        [To QC 1] < Today()+Days(1), "yellow",
        [Returned QC 1] > Today()+Days(1), "blue")



        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------