Forum Discussion

JessicaMatenga's avatar
JessicaMatenga
Qrew Trainee
4 years ago

Report Colour Formula

Hi
I currently run this formula to result in three colours, I want one more colour to the report but cant seem to get the correct formular -

If(Today()>([RFQ]+Days(9)),
/True

"#FF5B33",

//False

If(([RFQ]+Days(5))>Today(),

//True

 "green",

//False

"yellow"))

the last part of the formula I want is for any RFQ less than 3 days shows as white or ""
I keep getting an error.  

Please assist.



------------------------------
Jessica Matenga
------------------------------
  • Can you say English what you want the logic to be?

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • JessicaMatenga's avatar
      JessicaMatenga
      Qrew Trainee
      First line
      If Todays date is less that the RFQ date + 9 days colour rows Red
      If the RFQ date + 5 days is less than today colour rows Green
      Otherwise all jobs where RFQ date is greater than 5 days old colour rows yellow

      What I want is -
      RFQ date + 3 days less than or equal to Today - colour rows white or ""
      RFQ date + 4 days =< RFQ date + 6 days - colour rows green
      RFQ date + 7 days =< RFQ date + 8 days - colour rows yellow
      RFQ date + 9 days - colour rows red

      ------------------------------
      Jessica Matenga
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        Here is the syntax in Quickbase for an IF statement.   The syntax is actually much simpler than XL because you only need one if for most formulas. You just start with an SF and list your conditions and Quickbase will take the first one that is true if the first one is not true then it goes onto the next and the next until it finds one that is true or else it falls out the bottom and will take the value provided if none of the conditions are true. 

        It is very important to sequenced the tests in the correct sequence so I will leave that to you but for now I will give you exactly what you asked for which may not be what you need.  :)


        IF(
        [RFQ] + Days(3) <= Today(), "",
        [RFQ] + Days(6) <= Today(), "green",
        [RFQ] + Days(8) <= Today(), "yellow",
        [RFQ] + Days(9) <= Today(), "red")


        I actually highly doubt that the formula above will give you the results you want but it will give you the correct syntax so you can rewrite it properly.

        //RFQ date + 3 days less than or equal to Today - colour rows white or ""
        //RFQ date + 4 days =< RFQ date + 6 days - colour rows green
        //RFQ date + 7 days =< RFQ date + 8 days - colour rows yellow
        //RFQ date + 9 days - colour rows red

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