Getting Combined Names to dropdown in a form.
Our sheet has names captured in separate columns for first and last. I created an additional column that combines them with a formula to (First Last), however now I cannot use this in a drop down for a Form where the user can select their name from the list because the column has a formula in it. Is there a way around that?
Help Article Resources
Check out the Formula Handbook template!