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
-
580 Points
Posted 1 year ago
-
580 Points
-
4,430 Points
-
31,678 Points
-
580 Points
-
31,678 Points
-
580 Points
QuickBaseCoach App Dev./Training, Champion
-
65,522 Points
-
580 Points
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
[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
-
5,884 Points
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.
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.
-
5,884 Points
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
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
(Edited)
-
580 Points
I copied and pasted the formula, however none of the rows are colored.
-
580 Points
Let's try a different approach. I have calculated the days "overdue" (duration field). Need a formula for:
2-5 days overdue, blue
6-10 days overdue, yellow
11 or more days overdue, red
2-5 days overdue, blue
6-10 days overdue, yellow
11 or more days overdue, red
-
5,884 Points
> I copied and pasted the formula, however none of the rows are colored.
May be your report doesn't have any matching criteria as per condition. Can you please check that. or
try out this formula.
If(
[Date of Request]>(Today()+Days(2)) and [Date of Request]<(Today()+Days(5)), "yellow",
[Date of Request]>(Today()+Days(6)) and [Date of Request]<(Today()+Days(10)), "blue", [Date of Request]>(Today()+Days(11)), "red", "")
Do let me know if this formula works for you.
May be your report doesn't have any matching criteria as per condition. Can you please check that. or
try out this formula.
If(
[Date of Request]>(Today()+Days(2)) and [Date of Request]<(Today()+Days(5)), "yellow",
[Date of Request]>(Today()+Days(6)) and [Date of Request]<(Today()+Days(10)), "blue", [Date of Request]>(Today()+Days(11)), "red", "")
Do let me know if this formula works for you.
