Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

Formula to determine which checkbox is checked and return text value

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.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    Try this
    List(",",
    IF([Checkbox 1],"Checkbox 1",
    IF([Checkbox 2],"Checkbox 2",
    IF([Checkbox 3],"Checkbox 3",
    ..
    IF([Checkbox 20],"Checkbox 20")