Calculating todays register
Options
Hi All,
I'm trying to create a formula which will count a one for a ticked box and count 0 for a crossed box.
I have a date column along side and wish to only count todays totals
Is there a formula which can do this please? Or should I simply populate the boxes with 1's and 0's?
Thank you
Answers

Hi @Ed Gadd,
What field type are you using? If it is a checked box these have values of 1 when ticked or 0 when not. If using this the formula would look like this.
=SUM(RowName:RowName)
If you are using symbols like the one below there is a word value for each symbol and the formula would look like this.
=COUNTIF(RowName:RowName,"Yes")
Hope this helps!
John

Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!