Time of day
As an event planner I need to assign start and end times i.e. 9:00 a.m. - 3:00 p.m. to meetings and tasks that need to be completed.
I can obviously type in the times, but they do not sort correctly as anything starting with a "1" regardless of AM or PM will shoot to the top. I can put a "0" in front of any AM times, such as 09:00 AM, but things gets mixed up with you get to the hours that begin with a "1".
Is there any workaround to this or any function I'm missing? Is there any move in the future to include a 24 hour gantt chart of sorts?
Comments
-
Hi Karen,
Is it always the same time periods? Like 9am-3pm, 10am-4pm and so on?
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I would suggest taking the time you are trying to sort on and converting it to a 24 hour format. Then you can sort on that conversion. If you are trying to keep the 12 hour time with AM and PM, you can do the conversion in a helper column, hide it, then sort on the helper.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Time format column options are supposedly in-the-works... though there's no word on when we'll see it yet.
-
I know they are working on some things that have to do with time. I feel like since it is such a popular request, they will probably save the big announcement for their Engage conference if it is ready by then.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
It's in the works, and I hope that it will get released before Engage. I can't wait! I got so many clients that would have a use for this.
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I hope you're wrong and that It's released soon!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives