Multiple "if" conditions in one formula with row colorization

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

I need to color rows based on whether the date created (green) or date modified (yellow) is within the last 7 days. I know it's probably very simple...

or is there a way to print the report with the updated and new flags showing?

Thanks!

Photo of Dawn

Dawn

  • 0 Points

Posted 4 years ago

  • 0
  • 1
try this as a row colorization formula

if(

ToDate([Date Created]) > today()-days(7),"#00C957", // green


ToDate([Date Modified]) > today()-days(7),"yellow")



You can also just try "green" as a color.  Laura Hillier has a great app here to select hex color numbers.  When I use hex codes I always comment the color so I know what color it is.  That is what the // green is, it's a comment in the formula.


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









Photo of Dawn

Dawn

  • 0 Points
Thank you! I was close... :)