Best answer by jwag
I think you're missing a 2nd if (nested). Try the following:
IF(
{Last Renewal},
IF(
DATETIME_DIFF(
TODAY(),
{Last Renewal},
'days'
) > 365,
"🔴",
"🟢"
),
""
)
This says: if the renewal date is not blank, then check the date diff, otherwise if it's blank, return blank.
A little clarification, I get a green emoji in the blank record. All else works. This is the formula that works, but has a the green emoji in the blank record.
A little clarification, I get a green emoji in the blank record. All else works. This is the formula that works, but has a the green emoji in the blank record.
Screenshot of result of formula. Need Abernathy records be blank. Thanks ,Scott
+13I think you're missing a 2nd if (nested). Try the following:
IF(
{Last Renewal},
IF(
DATETIME_DIFF(
TODAY(),
{Last Renewal},
'days'
) > 365,
"🔴",
"🟢"
),
""
)
This says: if the renewal date is not blank, then check the date diff, otherwise if it's blank, return blank.
Fantastic, Thanks! I was thinking that I probably needed another If statement. That worked perfectly. Best, Scott
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.