Skip to main content
Question

Formula If([Date of Request])?

  • Mar 26, 2018 9:05 PM UTC
  • 0 replies
  • 54 views

Forum|alt.badge.img+11
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
This topic has been closed for replies.

Forum|alt.badge.img+11
  • Author
  • Qrew Corporal
  • Mar 26, 2018 9:05 PM UTC
Update...is 2 days or more

  • Qrew Corporal
  • Mar 26, 2018 9:11 PM UTC

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

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

Today()+Days(2)


  • Qrew Corporal
  • Mar 26, 2018 10:10 PM UTC
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", "")

Forum|alt.badge.img+11
  • Author
  • Qrew Corporal
  • Mar 26, 2018 11:59 PM UTC
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.  

  • Qrew Corporal
  • Mar 27, 2018 12:54 AM UTC
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",
"")

Forum|alt.badge.img+11
  • Author
  • Qrew Corporal
  • Mar 27, 2018 3:44 AM UTC
not working.  I get an "expecting ," alert.  Nothing gets colorized.  We will keep trying?  thx

Please post your formula which is not working

Forum|alt.badge.img+11
  • Author
  • Qrew Corporal
  • Mar 27, 2018 6:00 PM UTC
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