Discussions

 View Only
Expand all | Collapse all

Formula to determine which checkbox is checked and return text value

  • 1.  Formula to determine which checkbox is checked and return text value

    Posted 09-19-2017 19:08
    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.


  • 2.  RE: Formula to determine which checkbox is checked and return text value

    Posted 09-19-2017 19:13
    Try this
    List(",",
    IF([Checkbox 1],"Checkbox 1",
    IF([Checkbox 2],"Checkbox 2",
    IF([Checkbox 3],"Checkbox 3",
    ..
    IF([Checkbox 20],"Checkbox 20")


  • 3.  RE: Formula to determine which checkbox is checked and return text value

    Posted 09-19-2017 19:38
    That was the ticket.

    Cheers!