How to show/convert days to weeks on project plan


Hello All,

duration column circled in blue is automated as per the project setting

circled in red is all manual

I know weeks cant be determined from entering dates so i entered weeks manually in actual duration column and it has set the dates, but the roll up is in days

is there a formula I can use on another column to calculate the number of weeks and days to capture all this separately please? I need to calculate this for the target as well actual so i can measure the different in duration.

Any help would be appreciative

@Paul Newcome @Genevieve P. tagging you guys as always as you have been helpful to me in the past.

if anyone knows the answer please feel free to comment, i would really appreciate it.

I need this urgently please, thank you in advance!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!