Attempting to convert data from check boxes to Multi Select Dropdown
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?