Auto copy from one column to another, but only IF...

I'm looking for a formula to copy information from one drop-down column to another automatically, but only if a third column contains a certain word. Is this possible?

For example:

Column 1 could say say "Title" or "something else"

Columns 2 and 3 have a drop down menu of "In progress" and "complete"

If Column 1 says "Title," I want Column 3 to copy the information in Column 2. If Column 1 says "something else," I do NOT want Column 3 to copy the information in Column 2.

I hope this makes sense and someone is able to help!

Find more posts tagged with

Formulas

Accepted answers

Dan W

I think this is what you are looking for?

Put this in column 3

=IF(HAS(Column1@row, "Title"), Column2@row, "")

If column 1 has "Title" in it, this will copy whatever is in column 2. If not then it will be blank. If you want it to say something like "In progress" instead of being blank you will put the text in-between the ""

=IF(HAS(Column1@row, "Title"), Column2@row, "Text")

All comments

Dan W

I think this is what you are looking for?

Put this in column 3

=IF(HAS(Column1@row, "Title"), Column2@row, "")

=IF(HAS(Column1@row, "Title"), Column2@row, "Text")

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.