Hello,
I’ve been trying to work this out for hours but I’m afraid my knowledge of airtable formulas is quite nascent.
I’ve got this current formula:
IF(
{Due}="",
“”,
IF(
AND(
DATETIME_DIFF({Due},TODAY(),‘hours’) >= 12,
DATETIME_DIFF({Due},TODAY(),‘hours’) <= 48
),
“Due Soon”,
IF(
IS_BEFORE({Due},TODAY()),
“Past Due”,
IF(
IS_SAME({Due},TODAY()),
“Due Today”,
“Upcoming”
)
)
)
)
Which gives me different values depending on how much time is left in the “Due” column. I’m trying to add another variable that says that if checkbox column “Done” is ticked, disregard all the above formula and return value “Complete”. How can I go about doing this please?