If condition is met, copy cell to another column. If not, leave original value.

Hello, I am looking for help with a formula. I want to overwrite column A with the value in column B ONLY if column B has text in it. If column B is blank, I want column A to retain it's original value.

In Column A I've tried:

=IF(ISTEXT([Column B]@row), [Column B]@row, [Column]@row) ...and I get a circular reference

=IF(ISTEXT([Column B]@row), [Column B]@row) ...and I get blanks back where I want original values.

This feels like it should be easier than I'm making it. Is there a "take no action" symbol to insert for false result?

Thanks for your help!

Answers

  • Anson Cheung
    Anson Cheung ✭✭✭✭

    No, you can't. I am afraid you need to have another formula column to derive the value based on Columns A & B.

    Depending on your requirement, you may work around this by using Automation to change cell value or set form defaults but they are not flexible enough to reference values from another column.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!