Copy Row, Change Value
I have an automated workflow in Sheet 1 that copies a row to Sheet 2.
I thought I could then add an automated workflow in Sheet 2 that when this row is added, I can change the value of the cell in the Status column to "Stage 1". I can't see a way to do this without also providing a change in a cell.
Is there a way to just have this action occur (Status updated to "Stage 1") as soon as it has been copied to Sheet 2?
Answers
-
do you happen to have access to Smartsheet bridge or datamesh?
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
You should be able to use the trigger 'when a row is added and any field changes'. Occasionally, when I want to make sure the timing of automations follow the sequence I desire I will instead use the Created field as my changed field. This will ensure that the row is saved before making the subsequent change - which might be important if many rows are changing at the same time.
Does this work for you?
Kelly -
@Darren Mullen No, but I've been trying to make a case to the leadership team for awhile now. :)
@Kelly Moore I am not entirely clear on your suggestion. If a row from Sheet 1 is copied to Sheet 2, you use the Created field (changes to "Any Value"?) as the trigger, in this case, to update the Status to "Stage 1"? That sounds like a good suggestion, if I am understanding it correctly. I am not sure what you mean by "ensure[ing] the row is saved".
-
Yes, set up the automation as you described.
In this instance you shouldn’t have to worry about automation sequencing- when you have multiple automations happening almost simultaneously. In those cases sometimes the timing of automations aren’t always as expected. That’s what I was referring to.
I hope the Created date trigger works for your use caseKelly
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives