How do I update multiple cells when one cell is updated?

Kenya Asbill

Example A: If Done is checked, then Status is updated to Completed and Progress is updated to Full.

Example B: If Status is updated to Completed, then Done is checked and Progress is updated to Full.

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

You can automate two off of one, but you won't be able to fully automate all three. Once you manually change the data in a cell, it will remove the formula.

All comments

Paul Newcome

You can automate two off of one, but you won't be able to fully automate all three. Once you manually change the data in a cell, it will remove the formula.

Kenya Asbill

Thank you!

Paul Newcome

Happy to help. 👍️

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, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.