Help

Create Status based of date field

Topic Labels: Formulas
623 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Rachel_Ivory
4 - Data Explorer
4 - Data Explorer

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"
   )
)