Skip to main content
Question

Formula to determine which checkbox is checked and return text value

  • September 19, 2017
  • 0 replies
  • 69 views

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.
This topic has been closed for replies.

Try this
List(",",
IF([Checkbox 1],"Checkbox 1",
IF([Checkbox 2],"Checkbox 2",
IF([Checkbox 3],"Checkbox 3",
..
IF([Checkbox 20],"Checkbox 20")

  • Author
  • Quickbase Alumni
  • September 19, 2017
That was the ticket.

Cheers!