Sep 02, 2022 06:51 PM
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
Solved! Go to Solution.
Sep 02, 2022 07:43 PM
IF(
FIND('On Ramp', {SOP Status}),
DATETIME_DIFF({Today}, {Start Date :star:}, 'days')
)
If this doesn’t work, can you post a screen shot?
Sep 02, 2022 07:43 PM
IF(
FIND('On Ramp', {SOP Status}),
DATETIME_DIFF({Today}, {Start Date :star:}, 'days')
)
If this doesn’t work, can you post a screen shot?