-
Data Shuttle, Use sheet name to link which tab to reference
The tab number in Excel is easily changed and seems unreliable. In my experience, when the tab number does change, there isn't a method for Data Shuttle to alert you of any issue. It's typically an end user that alerts me that some data appears outdated. Preventing file changes in Excel would be one counter measure, but…
-
Automatic WBS Numbering
We have a work around but it takes multiple helper columns and complex formulas. You need WBS numbering 1 1.1 1.1.1
-
Consolidated Work List by Assignee
One thing that I've found lacking in Smartsheet, compared to other products I've used, is a central location where a user can see everything that is assigned to them in one place. This would make it so much easier for our users to find what they need, quickly.
-
Revert to previous versions of sheets instead of just the activity log snapshot
I just ran automation on an entire sheet instead of just the rows. I wanted to move tasks to a compact task repository, and it moved 364 subtasks that I wish it hadn't. Now, I have to go back and manually revert what I can. Luckily, most of the time, we upload comments and proofs to the parent tasks, which, because they…
-
Multi-row intake form
Hello , is there any way you can have multiple row entries in a single intake form?
-
Sort feature in Timeline View
I would love the ability to Sort within Timeline view. Having the two groups is not enough and with no sorting ability, it really limits the effectiveness of the information I am trying to show. For example, I may want to to see the projects that are being worked on. I would group by Resource, then Project Category, but…
-
Admin Access not working for Dynamic Views
Hello everyone, I'm Yashvardhan Vats. I have admin privileges for the Smartsheet source sheet (screenshot #1) and the relevant dynamic views (screenshot #2) , yet I'm unable to view the admin functions in dynamic view sheets (screenshot #3). I'm missing the blue gear icon displayed in the top right of the right of the…
-
Assistance with IF, AND, OR statements
=IF([Due Date]@row > TODAY(), IF(AND(Status@row = "In Progress", Status@row = "New", Status@row = "Not Started"), "Yes", "No"))) The goal is to flag items for escalation based on the due date and status. If the due date is in the past and the status of the risk or decision is in progress, not started, or new then I need to…
-
Target Start/End Date
Ultimately, I need a good way to track if we are completing tasks on time based on our original estimates because we have users that estimate a task will take 5 days and when it takes 15 they just change the dates, and the project status still looks green, when is reality it is behind. I would like to have target start/end…
-
Plan Asset Manager - will it capture orphaned assets already in the system?
Hi, I missed the memo on the addition of the Plan Asset Manager role, and just assigned our admin account this role today. I did some digging because we had a person leave recently who didn't transfer assets before she left, and now we cannot access these sheets/reports. When we deleted her profile, we thought we…