Is there a way to formulate IF value 'exists', Then.. etc

To give some context, I’m using Monday to log cases (like IT tickets). I have a Date Opened column which is just a plain date field, Date Closed column, which is another plain date field (I could automate it to automatically enter TODAY() when Status is changed to “Completed”), and a column to calculate “Days Since Opened”.

I started out by using this formula: DAYS({Date Closed}, {Date Opened}), but this leaves the field empty for currently opened cases.

Is there a way to format at it where if Date Closed “exists”, then return DAYS({Date Closed}, {Date Opened}), otherwise, substract today’s date with {Date Opened}?

For example:

IF({Date Closed}=Exists, DAYS({Date Closed}, {Date Opened}), TODAY(), {Date Opened}))

Thanks in advance!


Here’s one way:

DAYS(IF({Date Closed},{Date Closed},TODAY()),{Date Opened})

Jim - Subscribe to The Monday Man
Watch Our Latest Video: A Killer Combo:, Integromat & Google Sheets - Recurring Tasks Example

1 Like

That worked! THANK YOU!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.