Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

Converting Project Duration from days to weeks

Avatar

Level 3

I would like to create a calculated field to convert the project duration field from days into weeks? Any help will be appreciated.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 3

Please close this request. I found the answer below from one of the posts:

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