Change Cell Value not working
My sheet has a Start Time Column and End Time Column. Both are single select 'Restrict to dropdown values only'
I also have an "All Day" checkbox column
This sheet is populated with the use of a form
On the form, I have logic to only show the Start and End times when All Day is not checked.
I'm trying to populate the Start Date and End Date with values from the dropdown when All Day is Checked on the form
This automation does not change the cell value when All Day is checked. No errors, it just doesn't populate the fields
Answers
-
I notice you have the Trigger set to "When Rows are Changed" only. This means that the automation will only run if you change the checkbox after the row was submitted via the form. Is this what you are looking to do?
Try changing the trigger to be either "When Rows are Added" or both "When Rows are Added or Changed".
See: Trigger Blocks: Define When Your Workflow is Executed
Let me know if that worked!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thanks Genevieve
That was it. Thank you!
-
Wonderful! I'm glad I could help.
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives