Sign in to join the conversation:
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!
Try this:
=IF([Status]@row = "Open", TODAY() - [Created Date]@row, "")
Perfect! That works. Thank you so much Nic!
I accidentally deleted the wrong spreadsheet I looked on the site and it says that I can recover it and the deleted the items tab but I don't have any options on my Smart sheet app or web.
Hi, I have five Smartsheet accounts—four with editor access and one admin account. Recently, I’ve been unable to log in to one specific editor account. It shows the message “Too many failed attempts. Try again after one hour or reset your password.” However, I attempted to log in only twice, and the error appeared on the…
I shared a sheet with a smartsheet group for my team. The default view is set to Grid view for some, even though I created a shared filter view with the Table view. How do I enforce Smartsheet to only show the Table view when going to the sheet.
