Formula If([Date of Request])?
If date of request is less that today + 2 future days, I need my row to be red. The formula I am using is not working. Please advise.thx
Forum Discussion
- Update...is 2 days or more
If([Date of Request]<[TodayPlus2],"#CC0000","")
in another formula date field called [TodayPlus2], do the following:
Today()+Days(2)
- If the date is 2 days or more in the future, it will be the HEX color you pick.
If([Date of Request]>=(Today()+Days(2)), "#HEX", "") - Neither of these are working the way I have intended. I probably didn't explain well enough and have come up with something more...
If my [date of request] is more than 2-5 days prior to today, "yellow",
If my [date of request] is more than 6-10 days prior to today, "blue",
If my [date of request] is more than 11 or more days prior to today, "red"
Thank you for reviewing this again. - If(
[Date of Request]>(Today()+Days(1)) AND [Date of Request]<(Today()+Days(6)), "yellow",
[Date of Request]>(Today()+Days(5)) AND [Date of Request]<(Today()+Days(11)), "blue",
[Date of Request]>(Today()+Days(10)), "red",
"") - not working. I get an "expecting ," alert. Nothing gets colorized. We will keep trying? thx
- Please post your formula which is not working
- If(
[Date of Request]>(Today()+Days(1)) AND [Date of Request]<(Today()+Days(6)), "yellow",
[Date of Request]>(Today()+Days(5)) AND [Date of Request]<(Today()+Days(11)), "blue",
[Date of Request]>(Today()+Days(10)), "red",
"")
Line 2 has alert symbol - the word "AND" is highlighted in yellow and the alert message reads:
column 36 > Expecting ,
Thx- Hi Lynn,
I have just checked this formula and found the same error which you have mentioned. Try to use in a small case - and not AND. it will work. - In fact, if you ignore that error and save it then, Quick Base will change it automatically from AND to and.
If(
[Date of Request]>(Today()+Days(1)) and [Date of Request]<(Today()+Days(6)), "yellow",
[Date of Request]>(Today()+Days(5)) and [Date of Request]<(Today()+Days(11)), "blue",
[Date of Request]>(Today()+Days(10)), "red", "")
I don't know why it is expecting , after the AND. I will report it out separately to the QB Support team about it.
Thanks,
Gaurav - I copied and pasted the formula, however none of the rows are colored.
