Glad you got it to work! Just some advice, which I’m sure you realized in my app, is that you probably could have avoided any temporary columns in the google sheet itself. If you know your times are always going to be based on EDT, I think you could have simply created a template column in the glide data editor to join the date column and EDT. The template column would be your your date source for the calendar in the app. The glide calendar is incredibly flexible at interpreting text based dates and times in a variety of formats. Maybe you have reasons for doing it the way you did. 
Nothing wrong with how you did it, but just something to keep in mind for the future.
Here’s another thread for some inspiration.