Hello! I'm looking to use a formula that will calculate the percentage of tasks completed by row based on whether or not the check box is "checked." I have five check box columns, so if one is checked, the % Completed column shows 20%, if four are checked, 80%, etc. I know I need to use IF/And statements, but I keep getting errors.
Here's what I have done thus far to capture 100% for all columns when checked:
=IF(AND([1st Meeting Complete?]@row = 1, [SME Follow-up Meeting?]@row = 1, [Quote/Proposal Issued?]@row = 1, [Finalist?]@row = 1, Resolution@row = 1, "1"))))
Any help or guidance is greatly appreciated :)