Copying Cells to another sheet, formatting

Hi,

I am using a form to input data into a master doc and then have an automation to copy to another sheet for data manipulation.

2 issues-

1- When the cells are copied to the destination sheet (Data Manipulation) They do not take the next row, they go to a random row. How do I get them to take the next spot? This happens on some of my sheets but not all.

2- When the cells are copied to the destination sheet (Data Manipulation) they do not populate a formula that I have in the far right column. How do I make that formula apply to new rows added?

Thank you!

Find more posts tagged with

Accepted answers

Paul Newcome

First: The rows will be copied to the first UNUSED row in the new sheet. Even if a row is blank, if it previously had data in it before, it is considered used and will be skipped. Make sure to delete the rows themselves and not just the data from the cells in the row.

Second: Try converting the formula to a column formula.

All comments

Paul Newcome

Second: Try converting the formula to a column formula.

MakingCoolStuff

Hi Paul,

Thank you very much, that fixed it.

Not if someone else is struggling here, Right click on the cell that has the formula and click "Convert to column formula"

Paul Newcome

Happy to help. 👍️

Here is some more info on Column Fomrulas including a few limitations:

https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas

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.