Why is my automation to copy rows to other sheet missing data from certain columns?

I have an automation created that, when a row is added to sheet 1, the row is copied to sheet 2. Its working fine except it sometimes misses values from the "First Pay Date" column and the "IC" column and they dont get copied over. They will just be blank on sheet 2.

I made sure that under column properties, they are set up the exact same way. the IC column is a contact list column and the First Pay Date column is a date column. Its weird because it works for some rows but not others.

Find more posts tagged with

Automations

Workflows in Smartsheet

Accepted answers

Mike TV

@cugbug

Good morning. When new rows are added to Sheet 1, do they already have values within the "IC" and "First Pay Date" column or are those added after the new row arrives on Sheet 1? If they're added after, is it manually added or a formula pulls in data or an automation fills something in?

All comments

Mike TV

@cugbug

Dheeraj Goyal

Hi,

I am facing similar issue where sometimes it misses values from certain column. Did you figure out why this might be happening?

Thanks!

KPH

How and when are the missing values entered onto your first sheet? If they are entered after the automation has copied the row, they will not be included in the copy.

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.