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

mmatthias

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!

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")

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")