Organizing my data

I want to create a task management for my music ministry. There are so many related parts and I’m not sure how to initially design it.
A worship service would be the main record, or row.
under that would be hymns, anthems, and other music.
For each music topic, there are options of who is involved, such as organ, piano, guitars, winds, vocals, or any combination. This would be the option for each row of music.
Is there an easy way to set something up like this rather than using a checklist that has all the possible musician combinations?
John

Hi John,

Thank you for reaching out and it’s very nice to virtually meet you! My name is Thomas and I lead Customer Success here at Spreadsheet.com.

Your use case is a great example of how you can benefit from utilizing “Related Rows”. You’re on the right track with how you are planning to segment this data though.

My only recommendation would be to split the Workbook into at least “2 worksheets” to start. From there have a worksheet with your music as “Worksheet 2” and your music topics as “Worksheet 2”. After you’ve done that use the “Related Row” feature to link those rows together. I’ve included links to our help documentation and videos that go into more details about “Related Rows” below.

Help Documentation

  • Related Row (here)
  • Introduction to Related Rows (here)

Hope this is helpful John and let us know if you have additional questions.

Best,
Thomas Van Steyn
Customer Success Manager