Create a string of If Checked

Question

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
------------------------------

markshnier__you · Answer

np,try thisList (", ",IF([Improve Safety], "Improve Safety"),IF([Improve Quality], "Improve Quality"),etcIF([Less Physically Demanding], "Less Physically Demanding")if you want then listed vertically (which may look better on a report,&nbsp; then replace the first line withList("
",&nbsp; &nbsp;------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

sarahburres · Answer

I was just looking at the list formula wondering if that would work.&nbsp; I will try it.&nbsp; Thankyou!------------------------------Sarah Burres------------------------------

markshnier__you · Answer

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
------------------------------

sarahburres · Answer

Worked Perfect.&nbsp; Thanks!------------------------------Sarah Burres------------------------------

Forum Discussion

Create a string of If Checked