Question

Format elapsed days as # weeks, #days

Forum|Forum|6 years ago
September 13, 2019
5 replies
1011 views

Hi, I created a calculated column to calculate the number of days between Planned Completion and Planned Start. Is there anyway to format the result in number of weeks as opposed to number of days. Michele Banks Christus Health

Workfront

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

William

Community Advisor

I would love to know a valueformat that displays in progressively smaller units of measure like "X Weeks, X Days" but I've had to settle for the below, which would display the value in weeks with a decimal (e.g. "4.5 Weeks") displayname=Actual Duration linkedname=direct namekey=actualduration querysort=actualDurationMinutes textmode=true valueexpression=CONCAT(ROUND(DIV({actualDurationMinutes},60,8,5),1)," Weeks") valuefield=actualDurationMinutes valueformat=compound#M:D viewalias=actualduration William English T-Mobile

If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf

M

micheleb6836350Author

Thanks so much for responding. Unfortunately - it doesn't seem to like the format statement. Each time I try to add valueformat=compound#M:D The system erases it. displayname=Duration in Weeks durationunitfield=durationUnit.value linkedname=direct namekey=duration querysort=durationMinutes textmode=true valueexpression=CONCAT(ROUND(DIV({durationMinutes},60,8,5),1)," Weeks") valuefield=durationMinutes valueformat=compound viewalias=duration Michelle Banks Christus Health

William

Community Advisor

Hi Michelle, are you copying/pasting the entire code, or just certain lines? You should be copying/pasting the entire code. Also, what object type are you viewing? This was tested on Projects. William English T-Mobile

If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf

M

micheleb6836350Author

I'm using the Task Duration. Michelle Banks Christus Health

S

Sbhuta

Level 3

This actually worked for me. Thank you!!