Copy a Formula to Multiple Rows, but Keep One Column Ref in the Formula the Same?

Hey all!

I understand that when you copy a formula with criteria in certain columns to adjacent columns, it changes the column references to keep the relationship between columns the same (ie, column 10 has a formula that references col 1 & col 3, and copying the formula from col 10 to col 11 would result in the col 11 formula referencing col 2 & col 4)

Is there a way to keep a column reference as a hard reference no matter where it's place?

ie - Column 10 =Col1@row + Col3@row, Column 11 =Col2@row + Col3@row...where Col3@row reference never changes

Is there a symbol that can be put in front of it to always keep it there?

Thanks!

Find more posts tagged with

Formulas

Accepted answers

AmandaMerrigan

Looks like I just needed to reference the help center! I looked here but missed this one. For anyone else looking, just add a "$" to keep the column reference an absolute value.

All comments

AmandaMerrigan

Looks like I just needed to reference the help center! I looked here but missed this one. For anyone else looking, just add a "$" to keep the column reference an absolute value.

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.