Need a formula to copy data from one cell if criteria met in another cell.

Not sure if can be done. For the columns shown below, I need to copy text from the STATUS column into Status Phase only if column Dev Pipeline has a 1 or 2 in it.

Thanks for any suggestions.

Best Answer

  • John Shane
    John Shane ✭✭✭✭
    edited 01/10/24 Answer ✓


    Based on your criteria, the formula below should copy the information for you. It will return a blank Status Phase for any input in the Pipeline Dev column other than 1 or 2, and can be turned into a column formula.

    =IF([Pipeline Dev]@row = 1, Status@row, IF([Pipeline Dev]@row = 2, Status@row, ""))




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!