How to add column that shows start/finish time in minutes?
I see you can list a task in minute increments, e.g. 15min. We are creating a cutover plan and need to list a start & finish TIME: e.g. 9:00, 10:00, etc. Does Smartsheet have this as an "intelligent" column or just a text/number one only? Would be extremely helpful, so that folks can time the work and also, if you add another task, the timing would update.
Answers
-
Hi Daniel,
Unfortunately, Smartsheet doesn't have a time column type at the moment but they are working on it.
Please submit an Enhancement Request when you have a moment
There might me a possible workaround for your use-case/need.
Can you describe your process in more detail and maybe share the sheet(s)/copies of 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)
I hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
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.
-
Hi Andrée,
Thanks for writing back!
We are creating a detailed cutover plan and wanted to list tasks that need to be executed, not only in hour/minute increments (e.g. 1h or 20m) but wanted to see if Smartsheet has a column that lists start and end time, e.g. 09:00, 09:20, etc.
I know I can do this (as shown) via text but was wondering if there was a plug-in, etc that if you:
a) Make duration 20m
b) Make start time 8:00
c) It automatically makes the end time 8:20
d) Lastly, if you add/remove tasks, it increases/reduces the subsequent timings for the next tasks
Thanks for your thoughts!
Daniel
-
Daniel,
I am currently in a similar boat to do minute by minute cutover plan. No clue yet how we can do it on SmartSheet.
-
@Daniel William Maycock and @Saurabh_A
Do you have predecessors established? Are you using 12 or 24 hour format? Are you using colons?
-
Apologies, I didn't see your reply back in February.
I saw that Paul answered already!
Let me know if I can help with anything else!
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.
-
Any update on the Time Column type as stated back in February? Also, does this extend to the Gantt chart view? I have a system cutover plan that has over 500 actions that take place over a 2-day time period. The Gantt chart only shows down to the day so it is nearly impossible to see predecessor relationships and the critical path.
-
@Rich Stowell There is no update yet on a time column.
-
Your solution is for Excel and not Smartsheet so that it won't work, unfortunately.
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 guess that it will be released at this year's Engage Online Conference at the latest.
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.
-
Andree,
Can you explain further what to expect at the Engage conference regarding time and the Gantt chart?l
-
Unfortunately, I can't share anything.
Be safe and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
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.
-
You can find a solution in the following post
https://community.smartsheet.com/discussion/70827/how-to-create-a-cutover-plan/p1?new=1
-
@Andrée Starå Smartsheet still Releasing Time Calculation at Engage?
-
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 remember we were pretty excited for it last year as well. I am staying hopeful, but I'm not holding my breath.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 464 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives