Multiple Check Boxes in Cross-Referenced IF Statement

JBLS_
JBLS_ ✭✭✭
edited 12/09/19 in Smartsheet Basics

I have a master spreadsheet that details the progress of a project. I'm in the process of rolling all the information on that sheet into another that consolidates anywhere from 1-100 lines (check boxes) into a single line. The example below shows an example of 3 check boxes.

That being said, I'm creating a formula for a checkbox so that it will find any number of check boxes on the master sheet and, if they are all checked, check itself. I can sort the master sheet by the parameters I'm looking for and then individually reference each cell using an IF/AND formula, as seen below, but this is super time consuming. IΒ figured out aΒ SUMIFS workaroundΒ but I feel likeΒ there has got to beΒ aΒ simple alternative with cell linking, INDEX/MATCH/COLLECT, VLOOKUP, or another formula.Β Β 

=IF(AND({CABLE SCHEDULE Range 3}=1,Β {CABLE SCHEDULE Range 4}=1,Β {CABLE SCHEDULE Range 5}=1),1)

Thank you!

Comments