Should I use Join / collect or Multiple If in this situation?

Eunine Hsu

Hello Experts,

I need some help with this formula, I am trying to auto populate the Category Cell based on the check box value. Right now my formula only works on the first Sports checkbox value return.

=IF(Sports@row = 1, "Sports", IF(Entertainment@row = 1, "Entertainment", IF(Community@row = 1, "Community")))

Should I change to using a join and collect? But I won't be able to reference the header name right?

Any response is greatly appreciated.

Thanks,

Paul Newcome

I would suggest a "helper row". For this example I will use row 1, but you can use whichever row works best for you.

In this helper row, you are going to need to enter the text you want pulled (header name). Then the formula used to pull would be:

=JOIN(COLLECT(Sports$1:Family$, Sports@row:Family@row, 1), CHAR(10))

If you wanted to avoid the helper row, you would "add" your IF statements together instead of nesting them.

=IF(Sports@row = 1, "Sports ") + IF(Family@row = 1, " Family ") + IF(........................

Eunine Hsu

Thank you Paul! The helper row with the Join and Collect is a great solution and it worked!

Paul Newcome

Happy to help. 👍️