I have a board dedicated to an event to be held in a city in the middle of the US. I’d like the board to include the start and end times for the various parts of the event such that when my colleagues on the west coast are viewing the board and my colleagues on the east coast are viewing the board, we all see the times using the event location timezone, not the timezone of our current physical location. I know I could achieve this with a simple text field, but this information will be exported for other purposes and maintaining uniform, machine-readable formatting is essential.
That’s an interesting idea.
One solution that you might consider would be to separate the date and time into 2 columns, putting the time component into an “hour” column.
Jim - The Monday Man (YouTube Channel) Our latest vid: Reading REALLY Large monday Boards
What is Make & How can it help you with monday?
We Create Custom Solutions
Schedule a 1-on-1 Tutorial Session (for monday, Make or “Rocket Science”)
Thanks, Jim!
Using the Date column type and its built-in time function has a lot of appeal in that it essentially guarantees the time detail will be recorded in a uniform fashion that I can script stuff around when this gets imported into Google Sheets. (also - sorting by one column is easier than two)
Do you know of a way to make an hour column similarly restrictive? The only method I can think of is using a text field and that would be pretty easy to leave a typo in.
Thanks again!
If I’m understanding you correctly… there is an actual column type that is “hour”:
As far as sorting… you might consider adding a third column (formula) to combine the date and time and then sort by that. If you have a view setup with this sort, once you have it, you can hide it.
Thanks again! And thank you for not citing RTFM or something similarly appropriate. I could definitely have looked that solution up myself, but didn’t!
I’ll see how that column type reacts to contributors in multiple timezones and update this thread.
1 Like
You’re welcome.
Jim - The Monday Man (YouTube Channel) Our latest vid: Reading REALLY Large monday Boards
What is Make & How can it help you with monday?
We Create Custom Solutions - Your Make or Ours
Schedule a 1-on-1 Tutorial Session (for monday, Make or “Rocket Science”)
The Hour column type does not change the time being displayed based on each user’s timezone, so that solves that issue for me.
Another benefit – as my team prefers to group the sessions within our event by date, I can use the Hour column by itself (removing the Date column altogether) and have a much simplified board visually.
1 Like
Awesome. Glad everything worked out for you!
Jim - The Monday Man (YouTube Channel) Our latest vid: Reading REALLY Large monday Boards
What is Make & How can it help you with monday?
We Create Custom Solutions - Your Make or Ours
Schedule a 1-on-1 Tutorial Session (for monday, Make or “Rocket Science”)
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.