Proof decision data

Forum|Forum|1 year ago
February 27, 2024
2 replies
1204 views

Hello!

Need a report that shows a proof name, the approvers on each stage, and the time it took for them to approve the proof. I've tried writing a couple of different document version reports, but I can't seem to find a way to capture the time it took to approve. Any suggestions?

Thanks!

Workfront

MoniqueEvans

Community Advisor

If you make a document version report you can use the following code to show the wait time in business days for proofs still pending. If you want to show the wait time for proofs with decisions you'll need to modify the equation slightly so that the two dates are entry date vs decision date instead of entry date vs today.

displayname=Wait Time
shortview=true
textmode=true
valueexpression=CONCAT(ROUND(WEEKDAYDIFF({entryDate},$$TODAY),1)," Days")
valueformat=HTML

JustinWa2Author

Level 4

This is awesome, thanks so much!

I can't seem to figure out how to write the code to try the entry vs decision date. Would you know how that should be written?

kautuk_sahni

Community Manager

@justinwa2 just checking in! Were you able to get this resolved? If one of the replies above helped—whether it completely solved the issue or simply pointed you in the right direction—marking it as accepted can make it much easier for others with the same question to find a solution. And if you found a different way to fix it, sharing your approach would be a great contribution to the community. Your follow-up not only helps close the loop but also ensures others benefit from your experience. Thanks so much for being part of the conversation!

Kautuk Sahni

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded