Forum Discussion

SarahBurres's avatar
SarahBurres
Qrew Trainee
3 years ago

Create a string of If Checked

I am wanting to create a text field that looks at multiple check boxes to see which ones are checked.  


Text box would read: "Improve Safety, Improve Quality, Improve Efficiency"


------------------------------
Sarah Burres
------------------------------
Formulas and functions

4 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    np,

    try this

    List (", ",
    IF([Improve Safety], "Improve Safety"),
    IF([Improve Quality], "Improve Quality"),
    etc
    IF([Less Physically Demanding], "Less Physically Demanding")

    if you want then listed vertically (which may look better on a report,  then replace the first line with

    List("\n",
       



    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • SarahBurres's avatar
      SarahBurres
      Qrew Trainee
      3 years ago
      I was just looking at the list formula wondering if that would work.  I will try it.  Thankyou!

      ------------------------------
      Sarah Burres
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        3 years ago
        The LIST function is very handy to use because it only inserts a separator when there is something to separate.  It is smart enough not to insert a separator in between elements which are null.

        ------------------------------
        Mark Shnier (YQC)
        mark.shnier@gmail.com
        ------------------------------