-
Sheet automation loop
I am looking to understand how to break a loop so I can fix something. We are trying to remove columns from a sheet, but the automations keep replacing them on connected sheets before we can get them deleted on the other side. Is there a way to export a configuration so we can see all of the connected sheets? Also, how can…
-
Alert and Update Request in Same Workflow but Alert doesn't fire?
Hi All - maybe someone can spot what I'm missing here. I have an Automation that fires when our Admin sets a specific status column. When the value is "In Progress" it is supposed to send an Alert to the Requester, an Update Request to the Admin (or Admin and the Admin Backup) and then it sets a cell value (this step is…
-
Why does the entire sheet copy instead of just row?
I have set up an aumoted work flow- so that only rows check for at risk will get copied into another sheet. Instead the entire sheet is getting copied there. How do i restrict to rows only?
-
Merged: Automation Workflow Message Formatting
This discussion has been merged.
-
Merged: Copy Rows Without Formatting
This discussion has been merged.
-
Workflow not triggered when row changes
I have a two workflows to update Status and %Complete when either is changed by the user. For example; If %Complete is not 100% and Status is changed to Complete, then update %Complete to 100%. The trigger does not activate and row values do not change. Is there a delay or some other action needed to trigger?
-
How to auto-create a new set of rows once criteria is met?
Hello, I want the following columns to auto-create (with the filled in colors as well) below the already created ones every time "SITE" gets filled in. Do I use a formula, conditional formatting, or some other way? Thank you in advance for the help!!
-
How do I get two automations and a cell formula to execute in the right sequence?
I have a sheet the automatically coordinates documents. There are three things I am trying to get to execute in the right order. I understand the principle of workflow execution (the most recent modified workflow runs last). The variable I am adding is that between the two workflows is a formula in a cell that populates…
-
Pull dropdown menu options from one sheet into another based on a defined cell
Hello, I am curious if there is a way for Smartsheet to populate a designated column in one sheet with dropdown options from another sheet based on the conditions of a cell in the sheet the dropdown should appear in. For instance, if Sheet A has a specific value in the cell, you can pull in the dropdown menu from Sheet B…
-
Dynamic View - Search function
I have a Dynamic View report that has many entries, and users utilize it to update information when necessary. We're having issues because there is no search function and it's very inefficient to create a filter to search for one thing. CTRL-F doesn't even bring up a search in the desktop app so that's useless. Does anyone…
