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" -------...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp,
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
------------------------------
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
------------------------------
I was just looking at the list formula wondering if that would work. I will try it. Thankyou!
------------------------------
Sarah Burres
------------------------------
------------------------------
Sarah Burres
------------------------------
- MarkShnier__YouThe 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
------------------------------- Worked Perfect. Thanks!
------------------------------
Sarah Burres
------------------------------