Formula to determine which checkbox is checked and return text value

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I thought this would be simple, but I have failed.  

I am looking for a way to determine which of 20 formula-check boxes is checked and return a text value based on which box is true.  This is to find what current task a project is in.  I have tried the IF/& statement but it would throw errors or the output was incorrect.  I looked at the API_DoQuery, but not sure how to make it perform the task I want (lack of API knowledge).

Any thoughts for the community.
Photo of Neil Shepard

Neil Shepard

  • 1,248 Points 1k badge 2x thumb
  • frustrated

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
Try this
List(",",
IF([Checkbox 1],"Checkbox 1",
IF([Checkbox 2],"Checkbox 2",
IF([Checkbox 3],"Checkbox 3",
..
IF([Checkbox 20],"Checkbox 20")
Photo of Neil Shepard

Neil Shepard

  • 1,248 Points 1k badge 2x thumb
That was the ticket.

Cheers!