Mimic name manager (excel functionality) and logic in Forms
I have a sheet with a column that contains a column formula to index, collect a response from a "metric" sheet. I would like to include this column as a hidden field in a form so that I can apply conditional logic to then display the corresponding column and dropdown list for the user to select. This is a workaround solution I came up with to in a way mimi name manager excel functionality.
So in other words if the hidden field in the form is ABC, then dropdown column 1 will display with specific dropdown values that align to content in the ABC criteria field (that is currently driven by an index, collect formula).
The form will not allow me to add this hidden column if the formula is set to column formula, but then the scenario doesn't work if I don't have the formula to drive the response.
Help Article Resources
Check out the Formula Handbook template!