Change Cell Value not working

Detrie Zacharias

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

Genevieve P.

Hi @Detrie Zacharias

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

Detrie Zacharias

Thanks Genevieve

That was it. Thank you!

Genevieve P.

Wonderful! I'm glad I could help.