-
Report Filters for Duration not working?
Hello, I have a project tracking sheet where we layout target start & end dates for each subtask by using the predecessor and duration columns. I'm trying to create a report that shows when certain critical subtasks are rushed, so when "Task" is equal to "Approval" and "Duration" is less than "3d". I tried filtering by…
-
Flexible Date Formatting
I have discovered 27 distinct methods for formatting dates, not including variations in separators. Unfortunately, Smartsheet only offers 10 date format choices. In the IT field, aligning data with its intended use is crucial, and proper date formatting plays a significant role in multi-factor authentication. If a user…
-
How to add card and calendar view on Dashboard
Hi there, I want to add a few sheets in card and calendar view on a dashboard. Is this possible? I only see that reports can be added on dashboards, how do we also add sheets. Thank you, Esperanza
-
Table view - open in preferred filter
I am working in the new Table view and ask if there is a way to have the sheet open already in a filtered view? It would be even better if I could have multiple filters and set a preferred one. It is default in Grid view for the sheet to open with my last filter applied, so there must be a way to do the same in Table view.…
-
Reoccurring workflow start based on date in cell and end when a condition is met
It would be awesome to have be able to set a custom recurrence for a workflow that is triggered based on a Date Field instead of a hard coded date. This would be extremely useful for Update Requests and Alerts. For instance having it resend the UR/ Alert/ Approval until a condition changes that shows they have responded.
-
Collapsable "Workspace Shared To" window in Browse
When in the Browse screen, need the ability to collapse the "Workspace Shared To" window. It takes up valuable space, espcially while using a smaller screen on a laptop. Zooming out in the browser can help, but it would be nice to have the Workspace shared to window hidden as a default to make room for the item names in…
-
How to calculate days a ticket is open/closed
I am trying to calculate how many days a ticket remains open but I also need that formula to stop counting if the "Ticket Closed Date" column is filled in. I have tried a couple but they keep coming back as errors. There are multiple selections for the Status of Ticket column... Work Has Not Started, Work Has Begun,…
-
Can't Create a Single Grid Sheet anymore? Why did this change?
I am unable to easily create a grid sheet unless I do it through the Workspace panel. I used to be able to right-click anywhere in my sheets folder, for example, and add one, or hit the create button, which offered options. Now, the create option directs me to the same location as the left navigation, and there are so many…
-
How do I set SmartSheet to include attachments on the emails that it sends from automation?
Has anyone had success in having SmartSheet include attachments on the emails that it sends from workflow you set up? When I create a workflow in SmartSheet to send an alert to someone I want to have the email the user gets include an attachment. Currently my trigger for the workflow is when the data in a certain field…
-
Row Change Notification Being Triggered by Rows Added Through Form
Hi there I've setup a notification that's triggered by a row change. However when a new submission is made via the form (i.e. a new row is added via the form) it's triggering the notification as well. The notification is: "Trigger: When rows are changed AND when column1 changes to any value, or when column2 changes to any…