Expand my Community achievements bar.

Interested in getting an Adobe Workfront certification? Don't miss our AMA on June 10th, where our experts will be available to answer any questions you may have about getting certified!

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

Calculated Field for the plannedCompletionDate of a Project Task with a particular milestone applied.

Avatar

Level 7

Okay, I'm guessing this is a collections thing. But I've been working on something else and I got side-swiped with a reporting request that I'm working through now.

I'm looking to create a Project report which utilizes three calculated fields. The first two fields display the actualCompletionDate of two tasks with two different milestones applied. The third is a calculation of WEEKDAYDIFF between those two dates.

So, the first question: Is this even possible, and Help?

I've tried doing something like this...but it's not working:

IF({milestoneID}="5851d120007a5a899272acf155310bda",CONCAT({plannedCompletionDate}),CONCAT(" "))

I'm guessing it's "Collections And Output To Excel Time" but I'd prefer to keep everything within WF. Help?

-j

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Community Advisor

oh John. You have better ways to waste your time than this! ;-)

Get your happy butt over to the wf-pro website. It's all done here: https://wf-pro.com/textmode/text-mode-views-collections/ (or for your purposes, here https://wf-pro.com/textmode/text-mode-views-collections/#milestone-tasks )

(PS: I don't know that you CAN do a calculation that involves two different dates within a collection but... I'll sleep on it)

Avatar

Level 7

It's funny; that's what I ended up doing shortly after I posted this question. I have a custom view where I made collections for reporting the dates on tasks with particular milestones. Then, I output the Report into Excel and did the calculations there. I just needed the data and didn't want to totally break my brain. :D

Although, that would rule as a custom form field for calculations and the like...oh well, the beat goes on.

-j