-
Created form is it possible to display autonumber
Hi, I have a form to created that collects data where in order to avoid storing personal information I have set up a column assigning autonumbers to every case. Now the process is that the from is filled in by one team, the second team receives a notification to update. So we need to make sure the Auto number/ case numberā¦
-
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.ā¦
