-
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).
-
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,…
-
Distributing Savings Across Months Based on Term Date and Fiscal Year
Hello My Super Intelligent Smartsheet Community! I have attempted to solve my problem by breaking it up into pieces and I'm stuck. I think I've been trying to solve this for too long and my creative juices are fried. I have Service Providers we have contracts with. Each contract has a Contract Start and End Date and our…
-
Alert Someone Automation Error
Hi all, I have the following alert automation triggering off a date column, however since I added the "otherwise" it always sends two notification emails at the same time as if both conditions are being met. I played around and even when all dates in the column are in the next 7 days, to meet this first condition, it is…