You’re offline. This is a read only version of the page.
Announcements
Currently I manually enter data in a leads sheet in excel. I plan on using Forms to enter data into my existing excel table. This will be very handy while on my phone out in the field to enter any new data. I can map what information from forms goes into which column in excel. The problem I am having is (3) of my columns have data validation. My data validation uses a table and the indirect function so the list is dynamic. see below process and
Type Alt, D, L and select list then I type "=INDIRECT("tbl_name[table_column_name]")" of the table I'm pulling the validation from. How do I link the excel data validation list to populate the list of options in Forms?
Thanks, Chevychase77
Share
Report
All responses (
Answers (
522
