Auto check all check boxes in a column
I have a sheet with a check box column where end users select the check box to nominate a speaker which will trigger a separate workflow. The issue with individually selecting is that there can be upwards of 100 speakers on the list.
Is there a way to have an option for the end user to click one check box or choose "Select All" from a drop-down, and automatically update the value so each box in the list is updated to checked?
I'm okay with the delay if we HAVE to save/refresh in order for the checkboxes to populate but would prefer a formula over a workflow automation.
Any advice would be greatly appreciated. Thanks in advance!!
Help Article Resources
Check out the Formula Handbook template!