Hello ???Airtableonions??? ,

I have 3 issues am trying to solve. I have spent hours trying to figure them out, but I am no Airtable pro yet and seeking some help to see if they are possible.

I have a scheduling base for Volunteers helping at Non-Profits.


I have created a basic version below to give you an idea of what i am looking for.

Challenges:


#1. Volunteering with -


If multiple volunteers are on the (same date, same location, same start time, same stop time), I would like a column " :raising_hand_man: Volunteering with :raising_hand_man: " to show the names of each volunteer on the same detail.

#2. Double Booked -


If a volunteer is signed up for multiple details the same day I would like a column “ Double Booked/Overlapping Shifts ”, if they are double booked or have overlapping shifts.

#3. Relieving/Relieved by -


I would like two columns " Relieving Volunteer " & " Relieved By Volunteer " to list the names of those volunteers if applicable (ie. If one shift ends and another one starts. Shift one is 0800-1000, shift two is 1000-1400, shift three is 1400-1600, etc.)

Thanks for any help you can provide!