I haven’t been able to work on this as much as I wanted. But I’m trying to mimic your structure as much as possible and add the features you want. Here is what I’ve come up with so far:
Keeping the same Monday-Sunday column structure, the main change is having the item names as weeks/holidays and then having the Techs show up as options in a status column. This will allow you to automate populating their “Email” column, which is just a Text column, so you don’t have to type it in each time. I’ll go through that later on once I do some testing and determine the simplest way to automate it. You’ll notice I also separated the months by groups which is totally optional.
I actually figured out a much simpler way to set this up. First step is to have each Tech send a text message to your email. You should see it come in as ##########@serviceprovider.etc. Where the #'s are their telephone number and the serviceprovider.etc is each phone companies specific email address. For example mine is (cellphone#)@vzwpix.com. Once you have their “phone emails”, we can set up Integrations and Automations that will email them the information you want at a specified time. Since you have their phone number email, they will receive it as a text.
Let me know if this makes sense so far and if this is the direction/design you had in mind.
Thanks and have a great weekend!