Grid View - Default Values

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!

Find more posts tagged with

Sheets

Formulas

Grid View

Accepted answers

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.

All comments

Paul Newcome

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.