"Change Cell" Automation Not Working
I have created an Automation that auto-assigns a technician based on names in another cell within the same sheet and it is not changing my cell values:
The Trigger is set for when a row is added (rows are typically added in bulk as a copy paste from an Excel File)
The "Audit Assigned to" Field is a single-select dropdown
Best Answer
-
The way your trigger is set up, it will only trigger if all of those values are present at the same time. I think you are going to want to enter one, then click on "Specify another change" and make sure that it is set to "or". List the next, then keep doing that until all values have been entered individually.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
The way your trigger is set up, it will only trigger if all of those values are present at the same time. I think you are going to want to enter one, then click on "Specify another change" and make sure that it is set to "or". List the next, then keep doing that until all values have been entered individually.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thank you Paul! That was it!
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives