-
Workflow actions not being triggered by changing linked cell
I currently have 2 sheets, sheet 2 has dates cell-linked from sheet 1. In sheet 2 I wanted to use the "Change Cell Value" action whenever the linked date changes in the sheet to save "Yes" in a column called Date Change. However I see that even when the date changes the workflow is not being triggered. I have read that…
-
Order Execution for Automated Workflows
What order do the workflows get executed in? I have a workflow to move a row, but it can only be triggered right away. If that happens will other workflow items also execute? Other workflows trigger off the same change and I need ensure they don't get skipped.
-
Conditions and Automation
I have an automation which generates a document. I'd now like to add in some conditions to tailor which mapping is used based on a column value. e.g. if "Supplier" = X, use mapping 1 if "Supplier" = Y, use mapping 2 Is it possible to have nested IFs on the automation or do I need a separate workflow per supplier? Thanks…
-
Automated Update Request - some fields editable, others not
Hello, I am trying to set up an automated Update Request for % Complete updates on a project plan. When I test the automation sending it to myself, the system seems to be randomly selecting what item can be updated. For instance, sometimes it is only the task name, others the task name and percentage complete. As I need it…
-
Is there a way to create a flow chart that leads to a result depending on how the user answers?
Hi! I currently work in a manufacturing plant where in order to quote a new project we need to create a chart showing the number of people and the line speed required to run the project. I am currently the only one on my team that has the knowledge to make these, but would love to create a flow chart type system where…
-
Merged: Copy cell value(s) to another one if value/specific value is input in a specific cell
This discussion has been merged.
-
Reducing intricacies that need multiple child sheets to 1 simple solution (datamesh bi-directional)
@Genevieve P. Please please please make it so that you can either do a "report from reports" or have data mesh work in both directions. That or make it so that dynamic view can have logic for which fields are shown based on which column the current user is in. This is necessary because sometimes a user will be listed as…
-
Merged: Send Automation emails to multiple people like we send emails in 'TO' and 'CC'
This discussion has been merged.
-
Reports Filter Criteria Behaviour
Hello Exports, I am building a report based on a source sheet. The report should extract the rows based on the criteria "This Week". Can you please take a look the pattern of screenshots and confirm if this is an expected behavior ? The data's appearing only when I am using "Is One Of" but not the other conditions. The…
-
Copy Row Automation working inconsistently
Hi everyone, I am new to Smartsheet (only a couple weeks), and I'm running into a problem when using the "copy row" automation. I use the same automation set up on different sheets to bring the data I need into a sheet I use for calculations. However, on some sheets the automation works and on other ones it doesn't. By…