Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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 have an automated workflow what has a step, 'request and update.' The step shows ALL FIELDS, but when the actual request is sent to the end user, there are no fields displayed. There are no locked columns or rows on my sheet. Both I and the end user are licensed users shared with the workspace and sheet
For years we have used a contact column to gather emails via forms which allow us to send emails but also lookup in other columns supervisors, etc by calling another directory sheet with the user email. Typically, if you try to type the email address in via the sheet, it will auto recognize the internal contact and place…
Hi - we use Smartsheet as a workflow tool and saw a mass update of data on 7/21 which changed a lot of the workflow completion dates in our report. Any idea why this happened on how to prevent it in the future?
