Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 04, 2019 06:30 AM
I want to be able to have different icons display depending on the due date.
So far I have this, and it’s working well:
IF({Due Date} = BLANK(), BLANK(), IF({Due Date} = TODAY(), “ :red_circle: ”,IF(IS_BEFORE({Due Date},TODAY()), “ :alarm_clock: ”,IF(DATETIME_DIFF({Due Date}, TODAY(), ‘days’) < 6, " :warning: ))))
I want to add the condition that if my “To-Do” field is checked (it’s a checkmark field), then nothing is displayed. I tried this for that command:
IF({Due Date} = BLANK(), BLANK(), IF({Due Date} = TODAY(), “ :red_circle: ”,IF(IS_BEFORE({Due Date},TODAY()), “ :alarm_clock: ”,IF(DATETIME_DIFF({Due Date}, TODAY(), ‘days’) < 6, “ :warning: ”,IF({To-Do} != BLANK(), BLANK())))))
It doesn’t return an error but it also doesn’t make the field blank when To-Do is checked.
Any suggestions?
Dec 04, 2019 09:11 AM
Hi @Brenda_Carey - I think this will do it for you:
IF(
AND({Due Date}, NOT({To-Do})),
IF(
{Due Date} = TODAY(),
'🔴',
IF(
IS_BEFORE({Due Date},TODAY()),
'⏰',
IF(
DATETIME_DIFF({Due Date}, TODAY(), 'days') < 6,
'⚠️'
)
)
)
)
The first part of the IF statement is saying “if there is a due date AND the to-do is not checked, then continue”
JB
Dec 04, 2019 10:05 AM
Perfect!! Thank you so much. I’m still new to making formulas.