How do I automatically keep "link in from" in the Main Sheet when a new row is added from a Form?

emoser1978

I have the main sheet "Request Tracker with Form" and a separate sheet "Infrastructure-Access and Permissions" where updates automatically occur with a "Request Update Automation" but the reference link within the Access and Permissions-Completed column does not populate in the main sheet automatically, I have to go in and manually update it, this is not ideal.

These two sheets have the exact same Column name and checkbox properties.

How do I get the reference in the main sheet to update when the source sheet automatically updates?

Find more posts tagged with

Links

Accepted answers

All comments

SoS | Dan Palenchar

Hello @emoser1978,

I would recommend setting up a lookup formula and configuring it as a column formula. This will force all existing/ new rows to inherit that formula.

emoser1978

Good morning, thank you for the suggestion. I tried a few formula's that I found in other threads but I seem to be doing something wrong because I get error messages. If you have a formula in mind that I could try please let me know. Thank you!

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