JessicaMatenga
Qrew Trainee
3 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.

------------------------------
Jessica Matenga
------------------------------

### 7 Replies

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

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
• 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
------------------------------
• 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
------------------------------