Hello everyone,
I’m new to Airtable and I’m struggling to come up with a formula that calculates the different scenarios in relation to the timeframes for the tasks to be performed.
I would like to post a notice describing the situation in relation to the various remaining timeframes.
I am here so far, but i have an error that prevent notices to be displayed and I am lost… :
IF( Deadline = BLANK(),
/* Deadline is not entered */
"To be planned...",
/* Deadline is entered */
SWITCH( {End date} != BLANK(),
DATETIME_DIFF( Deadline, {End date}, 'days' ) >= 0, "DEADLINE IS TODAY !",
DATETIME_DIFF( Deadline, {End date}, 'days' ) < 0, DATETIME_DIFF({Délai}, TODAY(), 'days') & " DAYS LATE !"),
DATETIME_DIFF( Deadline, {End date}, 'days' ) > 0,
"Delivered on time"
)
)
Can anyone help? I would be very grateful
Have a Good day !
Gad