Count number of days if status is "Open"

Options
Raman Oto
Raman Oto
edited 12/09/19 in Smartsheet Basics

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!

Smartsheet Formula.JPG

Comments