Help

Making DATETIME_DIFF Conditional on another field

Solved
Jump to Solution
1114 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Mike_Thorington
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello -
I am using a simple formula of:

DATETIME_DIFF({Today},{Start Date :star: },‘days’) to calculate the number of days from the Start Date to Today.

I would like to combine an IF statement to do the following: I only want to return a number IF the Field ‘SOP Status’ contains the words ‘On Ramp’, otherwise return a blank result.

Any help is greatly appreciated.

Thank you

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto
IF(
  FIND('On Ramp', {SOP Status}),
  DATETIME_DIFF({Today}, {Start Date :star:}, 'days')
)

If this doesn’t work, can you post a screen shot?

See Solution in Thread

1 Reply 1
kuovonne
18 - Pluto
18 - Pluto
IF(
  FIND('On Ramp', {SOP Status}),
  DATETIME_DIFF({Today}, {Start Date :star:}, 'days')
)

If this doesn’t work, can you post a screen shot?