Applying a formula for the whole column

Hi! I currently have a formula for a specific cell in a row. I would like to apply that formula to all cells in the same column. I tried dragging the formula down as far as I can go, but when a new row is added from a form, it seems to add way down my sheet (not consecutively after the last entry) and the formula is not being applied. I have a suspicion that when I drag down my formula to all cells in the column, it is telling SmartSheet that the subsequent blank row (at the moment) is an actual entry b/c of the formula drag, therefore, the new entry from the form is being added after the last row I ended my formula dragging to. Any help would be great appreciated! And hope this makes sense!

Find more posts tagged with

Forms

Formulas

Accepted answers

AravindGP

Hi there.

All you have to do is right click on a cell where you have the formula and click on "Convert to Column Formula".

All comments

AravindGP

Hi there.

All you have to do is right click on a cell where you have the formula and click on "Convert to Column Formula".

Thu Nghiem

Oh my goodness!! It was right in front of my eyes! Thank you SO much!!

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.