Auto copy info from one cell to another.

I use a very simple formula, "=Name1".

The formula is in Column 2 of the sheet and it is a hidden column.

When the user enters text in Column 1, that text is automatically copied to Column 2 because of that formula.

This works fine for me. Now, what I want to do is pretty much the same, but combine info from 2 columns.


Column 1 is called "Color"

Column 2 is called "Animal"

Column 3 would be the result column.

So, I need a formula that if "Brown" is entered in Column 1 and "Bear" is entered in Column 2, then Column 3 would auto fill with "Brown Bear".

I'd appreciate any help or ideas the community may have.


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!