


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 help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Sign in to like this content
Total Likes
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)
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. 😄
Although, that would rule as a custom form field for calculations and the like...oh well, the beat goes on.
-j