I am trying to just create a very simple cell reference formula. I need some of my table headers to be up to user input.
In the first user-defined heading, I entered in ='Setup Page'!H19 in the header column, so that it would return the information the user typed into cell H19, but instead it just returns a 0. In the second one, I pointed it to cell I19, but it just returned 02 and erased the formula.
How do I get my table headings to reflect what the user enters in on the setup page?
This is the setup page where user puts in the names of the interaction headings and create the dropdown menus. (dropdown menus work)
setup info.jpg
Here is the table, and as you can see the headings are 0, 02, 03 rather than what the user entered in. The 0 should say "Follow-up email"; the 02 should say "Review given" etc.
table.jpg
Bookmarks