Can you calculate two time stamps on the same task?

Question

Report or calculation for task actual start date to when a task assignments is updated to a team? Find out the time from when the task entry date to when the original assigned user requested a team to work on the task.

Project is started - includes multiple tasks assigned to different Teams/Users

A task is assigned to Team ABC and Joe Smith assigns himself to the task. Leaves Team ABC assigned.

Joe Smith removes Team ABC and provides manage access to Team 123 and assigns Team 123 to wok on the task. Team 123 marks task complete.

I need to know when the task was assigned (project entry date) to when Team 123 was assigned to the task. Can this be done through calculated expressions?

Richard_Le_ · Answer

Hi Amanda,

An approach you could take is to have a custom form attached to the tasks you want to measure this date difference on and have two calculated fields on that custom form.

The first calculated field would create a timestamp when the task was assigned to Team 123 and would look like this:

IF(Team ID = 'Insert ID of Team123 here',$$NOW)

The second calculated field would then work out the difference in weekdays between the task entry date and the date that the task was assigned to Team 123 and round the value to the nearest whole number. It would look like this:

ROUND(WEEKDAYDIFF(Entry Date,Insert name of first calculated field here),0)

After creating the first calculated field, don't forget to save the custom form and exit it before going back in to create the second field. This will ensure that the first field is committed to your databased so it can then be referenced in the second field.

Hope this helps.

Best Regards,

Rich.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded