Date formula override

[symone]

I'm using the formula below to calculate the date difference between the day a position was opened to today (tracking number of days the position is open until filled). Is there a way to override that formula if the Position Status is listed as Filled or to make the formula only run on Positions with the status as Open. I don't want the running count of days once the job is filled, but don't want to lose the data point of the day it was opened.

DATETIME_DIFF(TODAY(),({Open Date}), 'days')

[Ron_Williams · Accepted solution]

This should work:

if({Position Status}="Open",DATETIME_DIFF(TODAY(),({Open Date}), 'days'))