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 ;-)😎
Help Article Resources
Check out the Formula Handbook template!