copy text from one cell to another in one sheet



solution seems to be simple ;-) I want to show text that I choose from a dropdown field in another cell in the same sheet.

[column one] [column two] [column three]

before choosing [blank] [options 1-5] [options 6-10]

after choosing [ =text no. 7 ] [options 1-5] [chosen option 7]

what kind of fomula do I have to enter in column one in order to show one of the chosen issues

e.g. ="([column one]@row) + ???

Thank you for brainstorming ;-)😎


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!