formula for a project to determine the #weeks based on the Project completion date

Options
This discussion was created from comments split from: Welcome to the online Smartsheet Community!.

Answers

  • Jacqui
    Jacqui ✭✭
    Options

    Hello

    I'd love to know what would be the best formula for a project to determine the #weeks based on the Project completion date and go backwards from there.

    For example 9/8 is the Project due date, so this would be week 0, then the previous task will follow under wk 1 and so on. This will be dependent on the dates constraints obviously, so there might be a few tasks under wk1.

    If anyone has any insights it would be greatly appreciated.

    Here is one example I found https://community.smartsheet.com/discussion/75456/weeks-to-project-due, but I need the due date to be reflected as week 0 ;)

    Many thanks,

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Options

    Are you able to provide a screenshot of your sheet for reference? We should be able to subtract the due date on that row from the max due date and then divide by seven. The ROUNDDOWN function should get what you need.

    =ROUNDDOWN((MAX([Due Date]:[Due Date]) - [Due Date]@row) / 7)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!