Project task end date

I use a start/end date and a %complete column to update various tasks in a Smartsheet and I have a question on updating the end date field. If I mark a task at 100% on a given day, why is the end date field not updated to that particular day?

For example, in the above task, if I change % complete to 100% today (4/13/23), why does the end date not update to the current date? The end date will just remain the same at 4/18/23.

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Think of it more as a "Scheduled" end date. If you want to show the actual end date, you would need to set up another date type column and use a Record a Date automation to record the date in this new column when the % Complete changes to 100%.

    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com