How to change column value whose property is Contact list before it is copied to another sheet

Hi,

I have this 2 sheets where if a row is added it is copied into another sheet. What I want is before the copying, there is one column which i want to have a contact and then copy to another sheet.

I have tried doing it using Automation, but changing a cell value is last step which can take place in automation, this is not successful. I have tried using helper column but it is not doing the job.

Can someone suggest any answer

Find more posts tagged with

Accepted answers

Antonie B

Hi Tasneem,

Have you tried setting up the Automation workflow over two workflows instead of trying to achieve this in one workflow?

While it is true that "Changing a Cell Value" is an end action on a workflow, you could schedule a 2nd workflow to use this change as the trigger, and use conditions to validate the information before initiating the copy action to another sheet.

Happy to help out with your workflow if you can share some more information of the process of adding the row to the sheet, to the point where it is ready to move across?

All comments

Antonie B

Hi Tasneem,

Have you tried setting up the Automation workflow over two workflows instead of trying to achieve this in one workflow?

Happy to help out with your workflow if you can share some more information of the process of adding the row to the sheet, to the point where it is ready to move across?

Tasneem

Hi Antonie,

It worked with 2 workflows. 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.