Thank you in advance for any help you can provide.
Since the Multi Select Dropdown option was not around when we created our form, we used a variety of check boxes to gather the required data via a form published on our website.
Now that the Multi Select Dropdown is an option, we would like to migrate that data over to a single column, instead of having 9 columns of check boxes, but we are looking at about 3000 rows.
I was hoping there was a simple formula to do this, without having to use the API and blow the dust off my pyhton textbooks from college.
I have not been able to figure out anything or find anything to make this work, does anyone know if there exists a formula that can possibly take 8 columns of check boxes, and use them to duplicate the necessary checks into a multi select dropdown menu?