Column formula - can you use in a form?
In a form can you add in a column formula as an option to show up on a form? I don't think so because I don't see it as one of the fields to choose from when building the form.
I was wondering if anyone knows of a workaround? What I'm trying to accomplish is if the user selects a certain location, the financial fields will auto-fill on the form as it does on the sheet in the background. This way they can make sure they selected the right location from the dropdown.
Help Article Resources
Check out the Formula Handbook template!