Report Colour Formula

Question

HiI 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()&gt;([RFQ]+Days(9)),/True
"#FF5B33",
//False
If(([RFQ]+Days(5))&gt;Today(),
//True
&nbsp;"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.&nbsp;&nbsp;Please assist.------------------------------Jessica Matenga------------------------------

markshnier__you · Answer

Can you say English what you want the logic to be?------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

jessicamatenga · Answer

First lineIf Todays date is less that the RFQ date + 9 days colour rows RedIf the RFQ date + 5 days is less than today colour rows GreenOtherwise all jobs where RFQ date is greater than 5 days old colour rows yellowWhat I want is -RFQ date + 3 days less than or equal to Today - colour rows white or ""RFQ date + 4 days =&lt; RFQ date + 6 days - colour rows greenRFQ date + 7 days =&lt; RFQ date + 8 days - colour rows yellowRFQ date + 9 days - colour rows red------------------------------Jessica Matenga------------------------------

markshnier__you · Answer

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
------------------------------

jessicamatenga · Answer

Hi MarkThanks for that, I had actually already done that formula but with and it still did not work.&nbsp; I was hoping there might be another formula similar to the one I first posted.------------------------------Jessica Matenga------------------------------

markshnier__you · Answer

If you did not get a syntax error then it is a question of getting the logic&nbsp; in the correct sequence.&nbsp; 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.&nbsp; The other alternative is to give some examples with real Dates for RFQ and tell me what "Today()&nbsp; 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.&nbsp;&nbsp;What I want is -RFQ date + 3 days less than or equal to Today - colour rows white or ""RFQ date + 4 days =&lt; RFQ date + 6 days - colour rows greenRFQ date + 7 days =&lt; RFQ date + 8 days - colour rows yellowRFQ date + 9 days - colour rows red------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Forum Discussion

Report Colour Formula