-
I want to send automated email to "assigned to", from a sheet, but only one reminder email vs mutlip
I have title, "assigned to" column, status(task 1), due date (task 1) columns, status(task 2), due date(task 2)…it goes for at least 10 tasks. The conditions to trigger the emails are, trigger 2 days before due date(when status is not equal to completed) and leave weekends trigger on due date(when status is not equal to…
-
Using forms to update current information in Sheets? Or another way to automate this process?
I have a form that we use to onboard new users. In the form, we would fill out information such as: contact name, position, department, manager, etc. Now, I want to use this same form and create a logic that would go something like this: Is the user "Current" or "New"?. So then the form displays certain fields depending on…
-
Smartsheet Automated Emails changing custom subject line
Good Morning, I've have several workflows setup to send out emails that are triggered by dates. I'm using the Alert someone and I have setup specific subject lines in each out these, based on the time frame of a requested completed date. This morning, I received a "Reminder: Smartsheet Name" email that was sent to all who…
-
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).