Unit count for Duration

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