Having my date formula change a field single select

Hi guys.

We have this formula telling us when a task is overdue:
IF(
{Due}="",
“7.Not Set”,
IF(
AND(
DATETIME_DIFF({Due},TODAY(),‘hours’) >= 12,
DATETIME_DIFF({Due},TODAY(),‘hours’) <= 48
),
"Date status. = overdue ",
IF(
AND(
IS_BEFORE({Due},TODAY()),
{Status}!=“Not started, partially complete”
),
“1.Past Due”,
IF(
{Status}=“Completed”,
“6.Complete”,
IF(
IS_SAME({Due},TODAY()),
“2.Due Today”,
IF(
WEEKNUM({Due})=WEEKNUM(TODAY()),
“4.This Week”,
IF(
WEEKNUM({Due})=(WEEKNUM(TODAY())+1),
“5.Next Week”,
“In The Future”
)
)
)
)
)
)
)

I would like that formula to also change the option in a single select field, I.E IF 1.Past Due make Due Date “Overdue”

Is this possible?

It’s not possible with Airtable features, but you could automate it with Zapier or Integromat.

1 Like