Duration Conversion

Rebecca Franklin

Hello all

I'm trying to import/link the milestones from project smartsheets into my program one and I'm having trouble with one of them as 9 out of 10 of them (including the program one) use a 5 day work week and 1 has a 7 day one. Is there a way to set it up so I can identify that the duration from the 7 day sheet needs to be converted to 5 in the program one ?

Bec

Hannah H

Hi @Rebecca Franklin,

I'm assuming that you want to convert the 7 day work week to be a 5 day work week, like the other projects? Have you tried using NETWORKDAYS to identify only the business days across the the project sheets?

Hannah