Skip to main content
Question

Formula to Count Total # of Fields the are Checked

  • February 17, 2020
  • 0 replies
  • 114 views
Is there a formula that can help me count the total number of checkbox fields that are checked/positive?  I have 12-15 Checkbox fields in a particular table, and I'd like to identify the total/sum that are checked for an individual record.

------------------------------
John
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • February 17, 2020
np,  Try this

Count(
[checkbox field 1],
[checkbox field 2],
[checkbox field 3],
[checkbox field 4],
[checkbox field 5],
[checkbox field 6],
[checkbox field 7],
[checkbox field 8],
...
etc.
...
[checkbox 12-15])

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
AdamKeever1
Forum|alt.badge.img+2
  • AdamKeever1
  • Quickbase Alumni
  • February 17, 2020
Use ToNumber to turn the true value of a checkbox to the number 1:


Sum(
ToNumber([field1]),
....,
ToNumber([fieldn])
)


...Just saw Mark's post and that is valid too.

------------------------------
Adam Keever
------------------------------
Terms & ConditionsAccessibility statement