Smartsheet Basics
Smartsheet Basics
Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.
"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.
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.
-
Thank you Paul! That was it!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 207 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
