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