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.

Task Report calculated field question

Avatar

Level 2

Hello, I'm looking to create a calculated field on a task report.

 

I would like the calculation to be task handoff date + task duration and the result to show in date and time format.

 

 I cant seem to find a field that gives me this without the dates moving to the next business day if a task is late (projected completion date, etc.)

2 Replies

Avatar

Level 2

I came up with the below calculation which seems to work, but when my duration has a decimal (.5 days, 1.5 days) the calculation doesn't notice the .5, it rounds down to day. 

Example:

Handoff date - 12/19 10 am

Duration - 1.5 days

Calculation -  12/20 10 am

 

Thoughts on how I get the system to notice the decimal??

 

valueexpression=ADDWEEKDAYS({handoffDate},({plannedDurationMinutes}/480))
textmode=true
valueformat=longAtDate
displayname=Due Date

Avatar

Level 2

Bumping this thread. Any suggestions?