I am trying to get a report to show with colors. I want any call over 5 days to be a color but I can't get the formula right.

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

Here is my formula. 

(ToDate([Date Created])> Todate([Date Created], Days(5)), "Red")

I am trying to get it to make anything over 5 days old show up as red in a report. 
having issues. 

Photo of Charles

Charles

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,448 Points 50k badge 2x thumb
Try this

if(Today() - ToDate([Date Created]) > Days(5),"red")
Photo of Scott

Scott

  • 334 Points 250 badge 2x thumb
If([Date Created]+Days(5)<Today(),"Red","")

Should work?  This should work!

Regards,

Scott

Seems like QBCoach beat me too it!  His will work great :smile:
Photo of Charles

Charles

  • 0 Points
Thanks! This worked!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,448 Points 50k badge 2x thumb
Great, btw laura Hiller has a public app which is very useful for colors.

https://laurahillier.quickbase.com/db/bhy8pumtp

I find that the red is too jarring to the eye and hides the text too much.  You might try, for example #D16587

IF(Today() - ToDate([Date Created]) > Days(5),"#D16587")  // red

When I use the codes, I like to add a comment to myself so i know what the color is.
Photo of Charles

Charles

  • 0 Points
This is great! Thanks! I booked marked it.
Photo of Charles

Charles

  • 0 Points
haha Thank you!
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 4,208 Points 4k badge 2x thumb
I have a free Row Colorization Tool that's available for anyone to use.  https://laurahillier.quickbase.com/db/bhy8pumtp