-
Multiple rows approval on single request
Hello, Is there are possibility currently in Smartsheet to have an approval for multiple rows in single approval e-mail? What I need, is to have a report sent once in a while (example week), that will include all the rows that needs an approval from manager. Then, with single "approve" button they will be processed. Or…
-
Planner/Roster/Scheduler that's not Project related
Has anyone built a planning tool for equipment and/or people? I've built one for equipment and it's taken me weeks and weeks to get the data in and it's still not perfect for what we need. There must be a better way. Each item is its' own thing, no child rows. We want to see where everything/everyone is Today, what/who's…
-
Format SUM function in a report
Hello, I have a report with a "simple" SUM function using the following: But the result shows as follows, without a dollar sign and missing a coma at the thousand point: How can I format it to show: $177,682 Thanks!
-
How to use a chart to show the Story Points remaining per Epic in a Product Increment?
Hello SS Community, I need to represent a chart of the remaining story points per Epic within a Product Increment. I have a Report that Groups Product Increment and then Epic Names and Summarizes the Story Points, as below. Any ideas? At present, I'm only able to represent the Story Points remaining on the Product…
-
Add Two Summary Fields To A Cell
Hello and thank you in advance for any help you might be able to offer. I'm just getting going in smartsheet. I've built my first sheet with Summary Fields (brief pause while I pat myself on the back). I'd like to take those summary fields and auto-fill cells in the sheet. I've figured out how to do it with one summary.…
-
Circular Reference Error
Hello! We are using an intake sheet to track project submissions. We have 5 cells on the intake sheet that we link in from a Project Metadata sheet within the specific folder for each project. The Project Metadata pulls in information from a Project Plan sheet. When linking the "Schedule at Risk" from Project Plan out to…
-
Auto Numbering between sheets
I have automation that allows for rows to be moved from one sheet to another based on "Request Type". Each sheet has a unique prefix in this column, using Auto Number. However, when a row moves from one sheet to another, I want the ID Number field to reflect the new sheet's unique prefix, instead of carrying over the…
-
Filter Report by End Dates
I have a report that I am using to 'look ahead' by two weeks. However, I would also like to see any past due dates in case tasks were missed from the previous week. Is there a way to set my filters to see both upcoming dates (by two weeks) and any past due dates? Currently, my filter is set up as status is one of 'in…
-
The difference between Limited and Restricted
Hello, I am hoping someone can really explain (over explain) the difference between Limited and Restricted permissions in sheet level automation workflows. I can see how Smartsheet defines it: Restricted (Default)—Only people who can view the sheet and have logged in to Smartsheet previously will be notified.…
-
Unable to see the edited text button with the correct values under approval workflow
I have customized the approval button text, and it worked for a while, but now it is back to showing approved and decline, without making any changes. what should I do to have the text show my preferred text instead of the default value?