Unit count for Duration
Sirius_200
✭✭✭
In the Duration column, instead of "d" for days, is there a way to show "wks" (for weeks) or "mons" (for months)?
Answers
-
Hi @Sirius_200
The Duration column can be filled out with the following formats:
- Weeks (2w)
- Whole working days (4d)
- Partial working days (3.5d)
- Hours (7h)
- Minutes (60m)
- Seconds (500s) and milliseconds (50000ms)
- A combination of hours, minutes, seconds, and milliseconds (4h 30m)
- Elapsed time (lead with an e) indicates elapsed time duration (e3d, e5h, e3.5d, etc.). A task with a duration in elapsed time ignores non-working time. The task will start and end in the amount of time specified regardless of working day length and non-working days in the sheet.
Here's the article with more information: Project Sheet Columns: Start Date, End Date, Duration, % Complete and Predecessors
Cheers!
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
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