I've built a very simple fusion scenario which allows a user with a request/review license to upload a document and attach a custom form which then triggers the creation of a proof. Works like a charm ... EXCEPT ... the document owner needs to be assigned as a Reviewer & Approver on the proof and th...

Ok, this is absolutely AMAZING! Thank you so much for sharing. I still don't have the hang of using EXISTS, so these snippets will really come in handy!

Oh wow. So simple, but I'm so glad I asked. Thank you @skyehansen!

I'm trying to clean up our HUGE list of templates and would like to see the last date they were used. This doesn't appear to be an option in a template report. Any help would be greatly appreciated! Thank you!

Ok, this is driving me crazy. It seems so simple, but for some reason it isn't working.I need to add a column to a project report that adds 5 days to the Last Update date to indicate when a project can be closed. Here is my calculation: displayname=Close bylinkedname=directtextmode=truevalueexpressi...

Hi all - new to Fusion and would like to connect to our Sandbox to do some experimentation and I'm already stuck. I've tried entering in http://ourdomain.sb01.workfront.com, which I'm able to Verify, but when I try to save the scenario, I get an error message: Account doesn't exist: Connection not f...

Thank you @skyehansen - your real-world examples made all the difference in the world. I'm not super familiar with the EXISTS functionality, but this made it much easier to understand. For anyone else who this may help, this is the final code and it works like a charm: Proofs:EXISTS:1:$$OBJCODE=PROJ...

Hi all - I'm working on some "Team" dashboards. I have a custom field at the project level that identifies which team the project is assigned to (Assigned to Team). Two of the reports I need to create for these dashboards are 1+ week pending Document approvals and 1+ week pending Proof approvals. I'...

Thank you, Joaquin! I will give this a try.

Hi all - need a little help. I've been asked to create a report that shows the number of days requests lived on the backlog prior to project conversion. This is my column code, which works perfectly:displayname=Days on backlogtextmode=truevalueexpression=ROUND(DATEDIFF({entryDate}, {convertedOpTaskE...