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!
Hello, In my source sheet I have a multiselect column called "Problem Code to be Updated". I am trying to use the reference sheet in the screenshot to identify if the multiselect cell in the source sheet has any of the problem codes where the "Technician Assigned Problem Code" is "Yes". The dropdown values are all taken…
Hello I know this might be very simple but I have tried everything to cross post a value from one sheet to another and I always get the wrong ref error or the unparseable one, this is the formula I'm trying to use, please help. =COUNTIFS({RE Projects Range1}, "Counter", {RE Projects Range2}, "Complete")
I’m looking for a cross-sheet formula in Smartsheet to calculate the average Turn Around Time (TAT) by specific Site Numbers. Source sheet details: Site Number (text/number) Turn Around Time (number; measured in days) Target sheet details: I have a row per site and want a formula in the Avg TAT column that returns the…
