Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
I am pretty new to Smartsheet and in need of some help. We are using smartsheet for an upcoming budget task. I have created over 50 different sheets. In each sheet there is a column with checkboxes. I want to have a user check the box when the specific task is completed. My question is, is there a way to create a consolidated sheet that totals up all of the checkboxes that have been checked off? In other words, if 5 sheets have checked off their box out of the 10 total sheets can I have the consolidated sheet show that "5 of 10 sheets have check the box"? Or have that spit out a percentage? I have used a percent column, but would rather use checkboxes to make it easier for the end user.
Thank you for your help!