Can an automation action copy data from one cell to another in the same sheet?

Hello, everyone!

I am helping my boss with a new template to manage our projects. I need an automation that copies data from one cell to another within the same row based on two conditions. Without more context this will sound confusing, but I will try my best to explain.

If one column is not blank, and the other column is marked "delivered" then I need the "Quoted Price" to copy into the "Final Price." I am not sure if this is possible, but if it is, does anyone know how to complete the automation?

Thank you!

Find more posts tagged with

Automations

Accepted answers

All comments

Andrée Starå

Hi @Bay

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

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

Here's a possible workaround or workarounds

3rd party integration, like Zapier or similar.

Is that an option?

I hope that helps!

Be safe, and have a fantastic week!

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!

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.