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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives