Skip to main content

Hi,

I need help from your brain because mine is out for this problem !


Actually i have this formula :


IF(IS_SAME({Date d’envoi}, TODAY(), ‘day’), ‘YES’)


To this formule i want to add 2 things :

if the date is after today add “AFTER”

if the date is before today add “BEFORE”


Finally, i need to have 3 conditions :

YES if today

AFTER if the date is after today

BEFORE if the date is before today


Thank’s for your help !


Matthieu

IF(IS_SAME({Date d’envoi}, TODAY(), 'day'), 'YES',
IF({Date d’envoi} > TODAY(), 'AFTER',
IF({Date d’envoi} < TODAY(), 'BEFORE')))

Reply