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

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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!