-
Remove an update request with a formula or workflow?
I have a sheet that will automatically request an update if certain parameters are met. But sometimes the fields get marked directly through the sheet instead of through the update request form. Is there a way to automatically remove the request update if the parameters are met through the sheet? For example if there is an…
-
How can I verify an update request was sent?
I have an update request workflow that sends to contacts in a cell and is triggered when a specific dropdown value is selected. After setting the value and saving the sheet, there is no update request icon on the left side of the row and they are not appearing in the update requests panel. However, the workflow itself is…
-
How to get symbol to automatically update in destination sheet when it updates in the source sheet
I have rows copying over to a new sheet whenever column C is a certain name the box in column J is checked. Source sheet: Destination sheet: I would like a formula to automatically update the symbol in column L of the destination sheet to match the symbol in column M of the source sheet when the rows of columns A, B, C, D,…
-
Add Google Doc merge to automatic document generation
It would be very helpful for our work if we could create a mapping to a Google Doc merge template, instead of a fillable PDF format, for the document generation workflow. Most of our forms are done using Smartsheet Forms, so fillable PDFs are not necessary, but we do create quite a lot of documents using the Smartsheet…
-
Workflow automations not allowing multiple sheet changes in one workflow
I am unable to complete multiple sheet changes in one workflow. For example, I can't record a date, change field to a certain value, AND clear another field at the same time. I assume this is by design, or am I doing something wrong?
-
How to delete/transfer existing JIRA connector workflow which was created by EX team member
For one of my existing intake process, we have connected the same with Jira board using JIRA connector and now the connector is not working and person who created has also left organisation. I am not able to create another workflow for the same sheet as its restricted and i am not able to delete the existing workflow as…
-
Workflow Automation: Copy changes to a new sheet
I manage a smartsheet that has a 2yr rolling forecast for 1,000+ expenses. At the end of the month, I would like to review and share all the changes that have been made to the "Cost" column. With workflow automation, I know that when a change is made to the Cost column, I can: Have the changes emailed to me at a frequency…
-
Workflow automation to alert contact via email when assigned task
I have a task list, and an automation setup to send an email to a person when they are assigned a task, in the email it sends to that contact, it sends a link that sheet where the task is held. But when they click on the link it requires them to create an account and login to view the sheet. Is there a way to have the…
-
Copy changes from Clone Workspace to Live Workspace
Hello all, We are working on a Workspace for a client and they have asked various changes to be made on their Workspace. We created a Clone Workspace to implement all changes and make sure it works correctly. The requested changes had to do with: Adding new columns to a sheet & update columns order Adding column formulas…
-
Copy rows to another sheet using workflow
Hello I have a workflow which triggers when a column (calculation) changes to value to anything above 15. The workflow then is set to move these rows to another worksheet, using a condition whereby status = 'open' from another column. All looks good, but nothing happens on the destination sheet when I run it. What am I…
