Duration Conversion


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 ?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!