Formula for Multiple Checkboxes
I have a sheet with submission form, in the form there are two different sections. One where they have to pick a checkbox option from a list of 4 and the other is one out of 8. I set it up this way to be able to provide details for each selection.
I'm trying to find a formula in the sheet so I can hide all the checkboxes and have two columns that auto-populate what was selected via checkbox in the two different sections of the rows. Their selections will be limited to 1 Job and 1 Department.
Help Article Resources
Check out the Formula Handbook template!