-
Decreasing a set number when a name appears
Hello! I am trying to create a formula for assignments where I can set a number (3), and when a name appears in a sheet, that number decreases for each time the name appears. I also currently have a formula where I have the number of times a name appears / 5 (we have 5 days of the week displayed each week so while the…
-
Automations Inactive - Still Sending Alerts
We have a sandbox sheet duplicated from a live sheet for 6 months now. The automations on the sandbox sheet are 'inactive' as we don't want any alerts being sent out while we run testing. However, just recently, email alerts have been sent from the sandbox sheet to the contacts and we know this for sure because the link in…
-
Lost Data
I'm using a sheet to track data on candidate outreach. There are multiple automations set up to record dates. Yesterday I had the brilliant idea to archive some of the data, the sheet had gotten pretty large over the last 1.5 years of using it, it was taking forever to load. I could have copied and pasted the data into a…
-
Card View "Auto Numbering"
In my line of work for Disaster Debris Recovery Operations, we use Smartsheet extensively—especially "Card View"—to organize field crews efficiently. We rely on the top-to-bottom order in each lane to set crew priorities, where the top card is #1, and each following card is numbered in sequence. To manage this, I built a…
-
Row automation - add to top of sheet
Add an option when using automation to move/copy a row to add the row to the top of the sheet.
-
Deactivate all automation on a sheet
It would be great to be able to "select all" when deactivating workflows in a sheet. I create templates and archive sheets and if I forget to uncheck the box then I have to go and manually deactivate each workflow.
-
Schedule a Form to Send
It would be nice to set a form to send on a schedule at the form level instead of an automation on a sheet- then we could trigger the form to resend if it wasn't submitted within a certain time frame (say 3 days).
-
Log automated workflow actions on the Activity Log
For compliance purposes, it would be helpful if the actions of automated workflows would log on the Activity log. For example, when automated messages are sent it would be helpful for the Activity Log to date and timestamp that action along with the name of the workflow. Lots of us using SmartSheet need robust audit trails…
-
Data Shuttle to automate identification of differences between two excel sheets with > 10,000 rows
Can it be done? Data Shuttle to automate identification of differences between two excel sheets (one column in particular) with over 10,000 rows. Basically what the title says. I want to automate a process and was pointed in the direction of Data Shuttle to accomplish this. I have a regularly reoccurring excel sheet that,…
-
Add Explicit Automation Order Execution
The ability to explicitly create an order of execution for automations rather than relying on the last modified date would be beneficial to Smartsheet Designers. My suggestion is to add a dependency dropdown box as part of the trigger box. The dependency dropdown box would self-populate with the names of automations…