Count number of days if status is "Open"

Raman Oto

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!

Nic Larsen

Try this: 

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

Raman Oto

Perfect! That works. Thank you so much Nic!