Expand my Community achievements bar.

The first Coffee Break sweepstakes in the Workfront Community is TOMORROW at 8:30AM PST! Share your Project Template and Timeline best practices or ask a related question for an opportunity to win Workfront swag.

Task Report calculated field question

Avatar

Level 1

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 1

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