I am having trouble with Row colorization coding. I would like to set it up as If a project status has been updated in the last 7 days highlight in yellow. The code I am using is If([Date Modified])), #EEE8AA

  • 1
  • 1
  • Question
  • Updated 6 years ago
  • Answered
Photo of Margaret

Margaret

  • 0 Points

Posted 6 years ago

  • 1
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,434 Points 20k badge 2x thumb
Try this:

If(Today() - [Date Modified] < 7, "#EEE8AA")
Photo of Margaret

Margaret

  • 0 Points
nope. didnt work :(
Photo of Margaret

Margaret

  • 0 Points
any other ideas?
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,434 Points 20k badge 2x thumb
Oops. Should be:

If(ToDays(Today() - [Date Modified]) < 7, "#EEE8AA")
Photo of Margaret

Margaret

  • 0 Points
Still no luck.
Photo of Mark_Shnier

Mark_Shnier

  • 700 Points 500 badge 2x thumb
[Date Modified] is really a date / time field type, so ....

If(Today() - ToDate([Date Modified]) < 7, "#EEE8AA")
Photo of Margaret

Margaret

  • 0 Points
This is the error message that I get:
The expression Today() - ToDate([Date Modified]) on the left hand side of the operator "<" is of type duration while the expression 7 on the right hand side is of type number. The operator "<" cannot be used with these types of expressions.
Photo of Mark_Shnier

Mark_Shnier

  • 700 Points 500 badge 2x thumb
Sorry,
s/b
If(Today() - ToDate([Date Modified]) < Days(7), "#EEE8AA")
Photo of Margaret

Margaret

  • 0 Points
That worked!
Thank you!
Photo of Margaret

Margaret

  • 0 Points
I have another one for you.... I am trying to create a checkbox that tells me if (yes/no) we have done a background check on a particular person in the last year. I am pulling this from a date field called "Last time background checked" Here is what I am trying:

If(Today() - ToDate([Last Time Background Checked]) < Days(365), ToBoolean"yes"

Here is the error message I am getting:

The argument list of the function ToBoolean must begin with a left parenthesis.


If(Today() - ToDate([Last Time Background Checked]) < Days(365), ToBoolean  "yes"
Photo of Mark_Shnier

Mark_Shnier

  • 700 Points 500 badge 2x thumb
If(Today() - [Last Time Background Checked] < Days(365), true,false)

or just

If(Today() - [Last Time Background Checked] < Days(365), true)




Photo of Margaret

Margaret

  • 0 Points
TA DA!!! Thank you!