-
Run an automation based off a primary automation?
I have been tasked to create an automation for alerting someone about entering in Smartsheet details the day after the primary automation sends them an initial request to input their information. My question is, is this even possible? I've been doing some experimentation and it does not seem that I am able to create an…
-
Columns appearing when a row is copied and moved by automation
My underlying primary sheet is populated by a form, I have a further automation set up which copies and moves the row to a new sheet if specific criteria are met, in this case "Yes" is selected from a drop down menu (this is in columns that are beyond the form populated fields). When the row appears in the new sheet, 5…
-
Excluding link to sheet in Alert Someone workflow
I know this is a commonly asked question and I have already submitted a feature request, but I am curious to see if anyone has developed a workaround for excluding the link to a sheet in Alert Someone workflow. Scenario: I have a sheet containing confidential information that users submit requests to via a form. The sheet…
-
Transitioning Existing Smartsheet Integration to Microsoft 365 GCC High
An existing client makes heavy use of Smartsheet integration with their current Microsoft 365 commercial tenant. They have some Power Automate / Flows built around this integration. They are exploring a migration to a Microsoft 365 GCC High tenant and I wanted to clear up a few questions regarding Smartsheet before making…
-
Copy row automation/keeping rows linked
Is there a way to keep rows linked from the parent sheet to destination sheet? So if we make changes to the row after the copying takes place to make sure that the destination sheet is also updated with any updates that happen in the row from the parent sheet?
-
I need a formula that allows the following:
If Modified B has “automation@smartsheet.com” then use Modified By column data but if Modified B is anything else place Modified B data in New Modified By column.
-
I need a formula that allows the following
If the Created By is Blank then insert the Create By data in the New Created By Column but if Created By is Not Blank then insert the Created By data into the New Created By column.
-
Workflow Automation changing cell contents
I have 2 'check' columns that indicate Start Confirmed and End Confirmed. I have 2 Workflow automations; When 'Start Actual Confirmed' is checked then 'Status' changes to 'In Progress'. When 'End Actual Confirmed' is checked then 'Status' changes to 'Complete' The issue I am running into is that when a user checks 'Start…
-
Delay automation trigger
Hello, Is there a way to change cell value after the request update entered? - what's happening is once this automation triggered, the cell value changed and that changed trigger another automation to send info to other people but the update has not opened yet for this request Does that make sense?
-
Do automations have an inactivity limit?
We realised that almost all of our automations, at random times, would freeze. We assumed due to no activity for over a month. Is that a thing? If so, is there a way to switch this feature off? I've only just been able to look into it and I don't see any time settings. I'm starting to suspect the reasons might have been…
