Skip to main content

Hello -


I am using a simple formula of:



DATETIME_DIFF({Today},{Start Date ⭐ },‘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

IF(

FIND('On Ramp', {SOP Status}),

DATETIME_DIFF({Today}, {Start Date ⭐}, 'days')

)



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


Reply