-
Automation enhancement - create complex workflows
As of now, the automation feature is good but we are limited to only a few levels down in our flows. We cannot create a flow that can change a cell value in one column, clear the value in another column, add a date stamp in a third column all within the same flow. Request - please allow for complex workflows so we can…
-
Merged: Automation enhancement - allow for the ability to copy data from one column to another colu…
This discussion has been merged.
-
Workflow Email Fields Not Populating
I have created a workflow on a smartsheet that generates an email with column fields. However, when the email goes out the fields are not generating the cell information from those fields. Instead it shows the field name. For example, {Last Name} instead of the last name of the person. I have done this with other sheets…
-
Forms with Workflow
Hello Experts, I need to perform a requests and processing task within smartsheet. Needs some guidance to acheive this with the following requirement User comes with a new request to process files - Need to build a form The requests should be tracked in a sheet and I should be notified with status as Open - The requests…
-
Change Cell Value Automation/Workflow
Hi Community - I feel like this is simple, but Im not sure how to make it happen inside of one automation. I keep making individual but I don't think that's good form. On our newsletter sign-up form, we ask "Sector of Work" on a multi-select field. From those results I want it to add a tag in another column (change cell…
-
Work flow - multiple cell change
Hello, I'd like to learn how to create a multi cell change workflow. See below. Thank you in advance
-
Is it possible to create a workflow to transfer indented rows to a separate sheet?
Is there any way for the workflow to trigger and move the indented row independently from their parent row to a separate mirrored sheet (exact same set up)? My specific scenario: Tracking form numbers that fall under different categories (series/subseries). The forms are indented to be nested under their respective series…
-
Automation trigger question
I'll try to describe the issue as best I can: I have a notification automation that is triggered by a row change (an attachment is added). The automation must also meet two conditions, both of which are checkboxes that must be checked to satisfy the two conditions. The first of these checkboxes triggers an earlier…
-
Update one sheet using Power Automate on several Excel files?
Hi there, I have a use case where I have a bot creating Excel files daily. I'd like to use Power Automate to tak the data from those Excel files and add it as rows into an existing sheet in Smartsheet so that I can add workflows to the data in those rows. I tried setting up a flow in Power Automate, but was stuck on two…
-
When Power Automate inserts data in Smartsheet, how to work correctly with formatted columns?
I have a Microsoft Form that my sales team fills out when they win an order. I have created a Power Automate flow to create a new line in Smartsheet and insert this data. I am using MS Forms + Power Automate and not Smartsheet's form because it also performs other actions outside Smartsheet. However, on the columns that…