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!
Good afternoon, Is it possible through either setting a specific duration or formula to begin a task in the afternoon of a Monday and end at the end of day on Tuesday? I am creating a high-level view of an upcoming store project where some tasks beginning in the PM and finish the following AM and other tasks that start in…
It would be great if we could limit which columns in a sheet we will allow a user to edit.
We have a team task list where we open up items, assign team members, create due dates, and update the status when closed. I am looking for a report / filter / view where I can filter closed items and group items by the assignee. Any suggestions?
Help shape the future of Smartsheet. Share your ideas and feature requests.