-
Automations included in templates
When a sheet template is created and saved it should include associated automations. This way, simple sheet automations like notifications, column population, formulas..etc.. can be part of a template.
-
Cascade automations based on folder
I think there's a need to be able to easily copy and paste automations between sheets, or, ideally, build a set of automations that apply to all sheets inside a folder. I want the same few, simple automations applied to every project I create. It feels like a waste of time to need to rebuild them manually 7x in a row for…
-
Automation Trigger Scheduling for Short Term Processes
The situation: I have a simple checklist for my team. I want to set an automation to send a reminder to the assigned team member weekly after a listed due date if they haven't checked off a task by that due date. Currently, if I want the reminder to send at a time relative to the due date, I have to set the trigger to Run…
-
Delete Rows using an Automation
Please create automation to delete Rows. Using the move rows automation, we are able to move records to an archive sheet. The problem then becomes we have to manually delete records from the archive sheet.
-
Match Multi Values to a Table?
Hello, I am trying to figure out how to VLOOKUP or MATCH or something else to return values from a table. In the example below, in the highlighted row, I would want it to return the three highlighted 'Assigned To' values in the table below. Is this possible? Or is there a better solution that I am not thinking of?
-
Workflow Subscription
Hello, I have someone who unsubscribed from the automation workflow notification and now needs to be added back. How can this be done? Thanks!
-
Change "end date" based on status changes
When an end date is used in a dependency setting, you can't use automation or formulas to change it. However, this is when it is critical (pun fully intended)! When someone marks an item as Completed status, it would be helpful if the sheet could update the End Date column to the date it marked completed. For dependencies…
-
Sharing a sheet via an automation
Would be great if it were possible to write an automation which would automatically share the sheet with people named in cells in the sheet. Ideally with controls to editing rights, etc. Certain reports we make need to be shared with three particular individuals in the organisation but are intended to be confidential. At…
-
Automation triggers not sending emails anymore
I have multiple notifications from a few days ago that say: Smartsheet Automation: Due to a recent automation permission or sharing change, the following people aren't receiving alerts from your workflow: I have changed the "fill in" columns to "contact list" and it looks like the automation is set up correctly, but still…
-
Updating cells to Formulas
I have a sheet that we track miles for vehicles for services so 1 column is for a A the next B service. those columns set of formatting against currant mileage and let the mechanic know if a service is due. the issue we have is the A is every 18K miles the B is 36K miles. When a B service gets done it resets the A service…
