How to copy a row with values not formulas

Hello,

I have an automation on a sheet to copy a row to another sheet each day. The automation works. My issue is that it copies formulas and they all break and return errors. How can I copy a row but have it copy values instead of formulas? Below is the Automation

This is the original sheet

This is the sheet where it is copied with the formula errors.

Find more posts tagged with

Accepted answers

Paul Newcome

In that case you may need to reach out to Support as copy and move row automations are not supposed to include formulas.

All comments

Paul Newcome

The copy row automation only copies static data. It does not push formulas. If those formulas are in at least two rows above and/or below the newly added row, Smartsheet's auto-fill function will pull the formulas down onto the new row.

Capitalg

Paul, Thank you for the answer and information. The sheet I copy into was a blank sheet until the automation ran. There are not any formulas in any of the other cells in the new sheet and this is the only row. It has only had the automation run one time.

Anything else I can try?

Paul Newcome

In that case you may need to reach out to Support as copy and move row automations are not supposed to include formulas.

Capitalg

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