Google Sheets: IF Formula with Checkboxes and Strings

Hello!

Coming back around to Google Sheets and Excel after a long time. Hoping I can get some help with building a logical statement.

This is what I want to do: I have five checkboxes and I've assigned Data Validation so when a checkbox is ticked, there the TRUE value displays for whatever I've set it to e.g. Granny Smith box is checked so Granny Smith will be the TRUE value. Now, I can take that TRUE value and create an IF statement in another cell to display that TRUE value and false value if the box is ticked or un-ticked respectively. BUT I want to display multiple TRUE values in the same cell for when a check box is ticked, so if Granny Smith, Fuji, and Gravenstein are ticked, I want one cell to display "Granny Smith/Fuji/Gravenstein".

Here are some screenshots:

1_Apples.PNG


And how the checkboxes are validated


2_Apples.PNG

try this formula in cell G3, and drag down:

Please Login or Register  to view this content.