-
Control Center - Add Archiving Dates to Archive Reports
Need to add an archive date for all projects archived in Control Center. There should be an archive date added to archive reports for all archived projects. Since there is a 500K cell limit on sheets, this would provide a practical date that can be used to manage sheets by date ranges and keep archive sheets under the cell…
-
Smartsheet Style: My Pom Squad & Me Gets the Caricature Treatment 🎨
Rocking my favorite Smartsheet swag 🧢!
-
Sum amounts within certain year and type
Hi, I have a report listing payment (i) amounts for various (ii) items and the (iii) payment date in long date format. I am trying to sum all the amounts per year and per item. Example: SUMIFS(amount, type = "paint", year = "2023") Adding up all the values in "amount" column if the type column is "paint" and the "date"…
-
Data Shuttle Running 5 Hours Early
Based on the log, all my nightly Data Shuttle workflows ran 5 hours earlier than they should have last night. (This may have been happening for a while and I just didn't have reason to notice.) Example: scheduled for 1900 hours, ran at 1400 hours. That's kind of a problem since the data for the day isn't all taken care of…
-
Saving a "Form" for later use without submitting as of yet
I have employees that try to start filling out their form as they work their 8-hour shift throughout before submitting. It seems that there are times that they leave for a while, and it automatically shuts down without saving their information that they currently had in there. I heard that there is not a way to save the…
-
Take Photos in Form with Tablets
We use Surface Pro's in my department for tracing areas to ensure compliance. When we complete our form (and we do several during our walkthrough), Smartsheet will not allow us to take a photo directly through the File Upload option so the photo will be submitted to the sheet like it does when using our phones or iPad.…
-
Access to All workspaces, sheets, dashboards and reports
It would be helpful if a System Admin or new role had access to all workspaces, sheets, dashboards and reports. Currently, we don't have a way to see how the organization is using Smartsheet. I can run a Sheet Access report, but, I don't have the ability to see how Smartsheet is being used.
-
How do I link a story to an epic via the Smartsheet to JIRA connector
I want to create a workflow that uses a Smartsheet form to populate a sheet that then creates relevant JIRA tickets. I have the connector working, but I can't seem to create a new story and assign it to an existing EPIC. The Epic Name and Epic/Theme fields don't do the trick for me and are difficult to troubleshoot.…
-
Summary of Children
Hello, I want to sum up budgets for 2025 - but only for children rows (as I use the sum(children()) function in the parent rows - parents rows cannot be assigned to a specific year). The following function does not work: =SUMIFS([Budget]:[Budget]; (date:date); IFERROR(YEAR(@cell ); 0) = 2025);…
-
Integration with EPIC
Has anyone done any integration with EPIC ? https://www.epic.com/ Pulling out of Epic and into Smartsheet Pulling out of Smartsheet and into Epic
