Formula If([Date of Request])?

  • 1
  • 1
  • Question
  • Updated 8 months ago
  • In Progress
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
Photo of Lynne8817

Lynne8817

  • 410 Points 250 badge 2x thumb

Posted 8 months ago

  • 1
  • 1
Photo of Lynne8817

Lynne8817

  • 410 Points 250 badge 2x thumb
Update...is 2 days or more
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb

If([Date of Request]<[TodayPlus2],"#CC0000","")

in another formula date field called [TodayPlus2], do the following:

Today()+Days(2)

Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
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", "")
Photo of Lynne8817

Lynne8817

  • 410 Points 250 badge 2x thumb
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.  
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
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",
"")
Photo of Lynne8817

Lynne8817

  • 410 Points 250 badge 2x thumb
not working.  I get an "expecting ," alert.  Nothing gets colorized.  We will keep trying?  thx
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
Please post your formula which is not working
Photo of Lynne8817

Lynne8817

  • 410 Points 250 badge 2x thumb
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
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,756 Points 5k badge 2x thumb
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.
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,756 Points 5k badge 2x thumb
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
(Edited)
Photo of Lynne8817

Lynne8817

  • 410 Points 250 badge 2x thumb
I copied and pasted the formula, however none of the rows are colored.
Photo of Lynne8817

Lynne8817

  • 410 Points 250 badge 2x thumb
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
Photo of Gaurav Sharma

Gaurav Sharma

  • 5,756 Points 5k badge 2x thumb
> 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.