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
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives