Grid View - Default Values

NRJW53

Hi Everyone, thanks as always for your help!

I have a quick question on the best way to apply default values when adding a new row to a grid view.

The idea is that if someone enters a new task name, then the priority and status column for the task would automatically update to "Medium" and "Not Started" respectively.

Then the user could overwrite it with their selected value when the status or priority changes.

Would be curious to know of any formulas that might work or just general thoughts if this is possible?

Thank you!

Paul Newcome

You would need to use a Change Cell automation if new rows are being added directly in the sheet. If new rows are being added via form, you can set the default values there and then hide the fields within the form.

Paul Newcome

You would need to use a Change Cell automation if new rows are being added directly in the sheet. If new rows are being added via form, you can set the default values there and then hide the fields within the form.

NRJW53

Thanks Paul, i was think formula, but never thought of an automation. Will give it a try!

Paul Newcome

Happy to help. 👍️

Column formulas can't be over-written, and non-column formulas may not always apply to every row. The automation is the most reliable way to make this happen (outside of form entry) and still be able to overwrite.