How to update formula in a column that has reference from another sheet and I added new data points

I have a reference formula in a column that picks up information from another sheet. I recently added more data to the this other sheet. My reference formula column isn't picking up the new data points.

Reference Sheet:

country Name country Code

United States US

Canada CA

I added Germany and Australia to Country Name column and Country Code

My sheet where I have formula isn't showing AU or DE for when the Country Name column in that file has Australia or Germany. Why would that be?

Find more posts tagged with

Accepted answers

All comments

Akaur

Never mind. I got my answer. I should slow down and edit reference range.

Andrée Starå

Hi @Akaur

I hope you're well and safe!

Glad you got it working!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

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.