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

Options

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!

Tags:

Best Answer

  • Dan W
    Dan W ✭✭✭✭✭
    edited 07/13/22 Answer ✓
    Options

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

Answers

  • Dan W
    Dan W ✭✭✭✭✭
    edited 07/13/22 Answer ✓
    Options

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!