I'm working on a spreadsheet where I schedule posts to various social networking sites.
Right now I'm posting to three sites and I have chosen five different times during the day that I intend to post for each site.
Thus, one site will only get posts from me at 8:45 AM, 11:45 AM, 2:45 PM, 4:45 PM or 8:45 PM. Another will only get posts at five other times and likewise for the third. Don't ask me why, it just seems like a good idea.
Right now, when I'm scheduling to post to say, LinkedIn, I need to look at my list for LinkedIn times. What I'd like to do is click a drop down list in one column where I select the platform (LinkedIn, Facebook, etc.) and then when I get to the column for time, I can click a drop down list that will only show me the times available for that platform.
This one's over my head.
I've attached a sheet that shows the platforms and times I'm working with. Below is what the data looks like.