Check a box if multiple columns contain an entry
I would like to create a column with a formula that will check a box if several of the following columns contain an entry (any kind of entry). The application for this equation is to confirm completion of a registration form. The sheet will be completed by registrants and I would like to confirm that ~10 registration questions have been completed. The column with the equation will be called 'Registration Complete' and will check if there is an entry in the next ~10 columns (since each registration question column has different properties, text, numbers, dropboxes, etc I am not looking for any specific criteria for what is inserted in the column, only yes/no is there data entered in the cell). Please let me know if there is a solution for this? I have found equations that can search for specific text, but here I am not looking for specific text and I am also looking for the equation to confirm values are input in a range of columns.
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!