Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Calculate each task's percentage completed by days gone by

Options
Katie Hill
edited 12/09/19 in Archived 2017 Posts

Hi everyone,

I have been trying to work out how to do this using lots of threads here but don't seem to be getting anywhere.

I want to automate the percentage complete for each task, based on the dates.

So if a task has gone past its end date, it would be 100% complete.

Can anyone help?

Many thanks,

Katie

Comments

  • Katie Hill
    Options

    I have used this:

     

    =IF((TODAY() - [Start Date]5) / Duration5 > 1, 1, IF((TODAY() - [Start Date]5) / Duration5 < 0, 0, (TODAY() - [Start Date]5) / Duration5))

     

    And it looks like it works... I don't totally understand it, though.

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    Options

    Katie,

    re: " And it looks like it works... I don't totally understand it, though."

    LOL Who does, really?

    You are a very trusting manager to assume, for example, that for a 5 day task, that 20% of the work is performed every day.

    Craig

     

This discussion has been closed.