Help

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

Create Status based of date field

Topic Labels: Formulas
240 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

1 Reply 1

Try:

IF(
   DATETIME_DIFF(
      {Manufactured By},
      TODAY(),
      'days'
   ) < 8,
   "priority critical",
   IF(
      DATETIME_DIFF(
         {Manufactured By},
         TODAY(),
         'days'
      ) < 15,
      "priority high",
      "normal"
   )
)