Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Oct 25, 2020 10:11 PM
Hi,
I am trying to get a field to show either Priority Normal, Priority high or Priority Critical depending on how far away from today the “manufactured by” date field is.
ie. if 3 weeks away priority normal
if 2 weeks away priority high
If 1 week away priority critical
Aby help would be greatly appreciated.
Oct 25, 2020 11:37 PM
Try:
IF(
DATETIME_DIFF(
{Manufactured By},
TODAY(),
'days'
) < 8,
"priority critical",
IF(
DATETIME_DIFF(
{Manufactured By},
TODAY(),
'days'
) < 15,
"priority high",
"normal"
)
)