Formulas in the automation workflows

I track both client addresses and project addresses in my sheet. I have a helper column that tracks whether the two are the same. I input all new project through a form, so I can't put an IF/Blank formula directly in the project address cell because if I enter in a project address, the next line breaks the formula.

I'm trying to find a way to automatically copy the client address into the project address column if I confirm they are the same in my helper column. However, the workflow automation doesn't let me use a formula. Below is a screenshot of what I'm trying to do, but it just copies the formula as text.

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

You will need an additional column to house the formula.

First Column = [Client Address]

Second Column = [Project Address]

Third Column = [Same?]

Fourth Column = [Address]

The column formula to apply to the sheet in the fourth column would be

=IF([Same?]@row = "Same as Client Address", [Client Address]@row, [Project Address]@row)

Evani

I wouldn't want to add a fourth column, I want it pasted into the "project address" column.

Paul Newcome

In that case, you will need to do it manually or with the API, premium add-on Bridge, or some other 3rd party app.

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