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",
//Fal...
Forum Discussion
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
------------------------------
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
Qrew Legend
Qrew LegendHere 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
------------------------------
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
------------------------------
- Hi Mark
Thanks for that, I had actually already done that formula but with and it still did not work. I was hoping there might be another formula similar to the one I first posted.
------------------------------
Jessica Matenga
------------------------------- MarkShnier__YouIf you did not get a syntax error then it is a question of getting the logic in the correct sequence. I am happy to try to work that through with you here or if you can better explain by what you meant by this to be honest tge laqst three conditions below did not make sense to me so I was guessing what you meant. The other alternative is to give some examples with real Dates for RFQ and tell me what "Today() and then I would understand what you mean.
Like a little chart with the RFQ date and the value for today and what color you want.
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
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- I will go through the existing formula as it works with the three colours -
First condition -
If(Today()>([RFQ]+Days(9)), "#FF5B33",
- If todays date is more than the RFQ date plus 9 days then those rows are coloured red
Second condition -
If(([RFQ]+Days(5))>Today(), "green",
- If the RFQ date plus 5 days is less that todays date then those rows are coloured green
Otherwise - "yellow"
- All other rows where RFQ date plus days 6-8 are coloured yellow
I am after a Third condition that will have no colour for jobs that where the RFQ date + 3 days
------------------------------
Jessica Matenga
------------------------------