How to change Automation Trigger from "Changes:" to "Changes To:"
Hello Community,
I have set up a sheet and a form. The form has various drop-downs asking different fellows for their unique identity numbers.
I am trying to copy the rows to the fellow's specific sheet when the drop-down is their unique identifier number.
I am setting it up for 20 fellow drop downs, out of these the 19 drop downs are giving me the option to select the identifier number in the automation and it displays
When "Unique Identifier, Changes to: and I can select the identifier.
But for Fellow 1, it only gives me the option of "Changes" and does not let me select or enter the unique identifier.
Am I missing something here?
Fellow 1 is set up similarly
to other fellow columns as drop-down.
Help will be appreciated.
Answers
-
For something like this, I would create a helper multi-select dropdown type column with a formula to output all ID numbers on the row with line breaks in between (so they are seen as separate options).
From there the trigger would be looking at a single column changing to any value and a condition of the single column having that particular ID number in it.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives