This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Scheduling appointments in Appsheet in EST for users in different time zones

Posted on 05-24-2024 07:25 AM
alexczar
Bronze 3
Bronze 3
Reply posted on --/--/---- --:-- AM

I've created an App that's integrated with Google Calendar and that calendar is already set under EST. I am currently based in CST and we have other users that are in MST and PST as well. When I tried to book an appointment for 5 PM on the Appsheet calendar, I noticed that it booked it for 6 PM instead. Does anyone here have any solutions on how to overcome that issue? Ideally, I'd like for them to see the schedules in EST and be able to book the appointment in EST as well. I've tried several expressions but I haven't been successful. 

Any advice would be much appreciated.

Solved Solved
1 6 392
Topic Labels
Jump to Solution
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
MultiTech
Gold 4
Gold 4
Reply posted on --/--/---- --:-- AM

Definitely something that can be a bit of a trick to get right, but you can definitely do it with a formula - and also accounting for daylight savings!

When I started putting together the answer portal, and got to all of the scheduling stuff for my apprentices... I had to figure this out. I've got people that I meet with all over the world, and I need time stamps to be centralized in one time zone so that everything makes sense.

Formula and explanation in the Answer Portal 

View solution in original post

Jump to Solution
6 REPLIES 6