Workflow to copy a cell and paste its value in another cell when the first changes.

Hello everybody

I'd like create a workflow to copy the value of a cell date type when it changes to another cell in the same sheet.

I can trigger the workflow when there's a change, however I can find a way to bring this value to the other column without using DataMesh or Formulas. In my case I want to avoid to use these systems in order to build a third solution for users that don't have Data Mesh or don't depend on formulas to update columns.

Find more posts tagged with

Automations

Update Requests

Workflows in Smartsheet

Accepted answers

All comments

Mike TV

@Fernanda Guizi

This doesn't currently exist. You'll need to submit an Enhancement Request.

Andrée Starå

Hi @Fernanda Guizi

I hope you're well and safe!

Why wouldn't it work with formulas?

Here's the link to submit the idea.

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Clarkathon

@Andrée Starå If there is a formula that could do this I would love to know. I have been trying to get this to work for a bit of time. Currently I have a helper cell that literally is just =WORKDAY(TODAY()) and whenever this changes I want to copy one cell in a row to another cell in a the same row.

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.