Formula regarding Checkbox Column
Hello Smartsheet community,
I'm attempting to write a formula for a project plan type grid sheet. One of the columns is a checkbox to represent when the item is complete. I'd like to write a formula that counts all the checked activities to get management a % complete value based on how many boxes are checked and the formula auto populates when employees check more activities off. Can someone help me write this formula and tell me if i should write it directly into the sheet or write it in sheet summary?
Help Article Resources
Check out the Formula Handbook template!