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