2

Hello,

I'd like to count the number of days from created date to today only if the status of a ticket is "Open". If it's "Closed" I'd like it blank, I'm not sure how to do this.

Here is an image of the ideal results

Thanks!

Functionality

Comments

Try this: 

=IF([Status]@row = "Open", TODAY() - [Created Date]@row, "")