Sign in to join the conversation:
I am trying to find the average of checkboxes in a row.
At row: "Clear pads as needed..." I want the % to add up as each box is checked.
What is the formula?
Appreciate the help.
Hi Jenn,
Try something like.
=COUNTIF(Stanley@row:Walter@row; 1) / COUNT(Stanley@row:Walter@row)
The same version but with the below changes for your and others convenience.
=COUNTIF(Stanley@row:Walter@row, 1) / COUNT(Stanley@row:Walter@row)
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
This worked great. Thank you for the quick response! Much appreciated.
Excellent!
Happy to help!
Andrée
Great solutions above!
Thoughts on if the Check-boxes in the Row are separated with date columns? I have a sheet with Check marks to identify the task is completed, and ask the assignee to define the date it was completed on. Actually, I often specify a goal date, and when completed the assignee enters the actual date when checking the box.
I've not sorted out a way for this to function.
Any help greatly appreciated,
Chris
Hi @Chris Egge
Thanks!
Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
I hope that helps!
Be safe and have a fantastic week!
Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
I've got the following formula in a Check Box column to check when something is due in the Next 3 weeks. =IFERROR(IF(AND(WEEKNUMBER([Projected Cleaning Date]@row ) = WEEKNUMBER(TODAY()) + 3, YEAR([Projected Cleaning Date]@row ) = YEAR(TODAY())), 1), "") I have them for 2 weeks, 3 weeks, 4 weeks, and 5 weeks. These stopped…
I'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…
