Task Report - Display Dates of tasks in Columns instead of rows.

Hi All, I've advanced further with this method by trying to subtract two milestone dates to determine amount of days in between milestone completion dates. is there a way to SUB() two milestone dates from each other in the same method/format? displayname=MC STATUS days past G0 listdelimiter= < div > listmethod=nested(tasks).lists textmode=true type=iterate valueexpression=SUB({milestone}.{ID}="57b32d6d0065003c0a783e6533bd7c0c".{plannedCompletionDate}, {milestone}.{ID}="5c65e2360253cb5671681ab4d1389c47".{plannedCompletionDate}) valueformat=HTML Joe Salas Logitech International SA

Hi Joe, Valiant attempt, but iterations do not allow "math" (or sorting). Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads

Doug, your next challenge... should you choose to accept it! Similar to Chris' issue, but I'm trying to super-nest IF statements. displayname=Task Status listdelimiter= listmethod=nested(tasks).lists textmode=true type=iterate valueexpression=**Is where I'm struggling** valueformat=HTML This valueexpression works, I get my task status full name, not just the status key: valueexpression=IF({teamID}="Team A", IF({status}="NEW","New", IF({status}="CIA","Creative", IF({status}="YVX","Review", IF({status}="BTX","Revions", IF({status}="MJZ","Deployment", "")))))) This valueexpression does NOT work, the status names for Team A show, but for Team B I just get a blank spot in that row: valueexpression=IF({teamID}="Team A", IF({status}="NEW","New", IF({status}="CIA","Creative", IF({status}="YVX","Review", IF({status}="BTX","Revions", IF({status}="MJZ","Deployment", IF({teamID}="Team B", IF({status}="NEW","New", IF({status}="CIA","Creative", IF({status}="YVX","Review", IF({status}="BTX","Revions", IF({status}="MJZ","Deployment", "")))))))))))) Can I do crazy super-nesting like this??

Hi Heather, Looking at your original: valueexpression= IF({teamID}="Team A", IF({status}="NEW","New", IF({status}="CIA","Creative", IF({status}="YVX","Review", IF({status}="BTX","Revions", IF({status}="MJZ","Deployment", ""))))) ) I suspect you're missing this: valueexpression=IF({teamID}="Team A", IF({status}="NEW","New", IF({status}="CIA","Creative", IF({status}="YVX","Review", IF({status}="BTX","Revions", IF({status}="MJZ","Deployment", ""))))) ,"This Is Not Team A" ) Without which would resolve to a blank beside anything but Team A; and a blank beside Team A for an unknown status, I would add, which is why I'd recommend "dropping out" to the status, just to be safe: valueexpression=IF({teamID}="Team A", IF({status}="NEW","New", IF({status}="CIA","Creative", IF({status}="YVX","Review", IF({status}="BTX","Revions", IF({status}="MJZ","Deployment", status )))))) So a general pattern for translating such Team specific statuses could be: valueexpression= IF({teamID}="Team A", IF({status}="NEW","New",...,status), IF({teamID}="Team B", IF({status}="NEW","NewB",...,status), ... )) As for "can I do crazy super-nesting like this??": sure you can (as have I), subject only to your imagination, patience, and the 2000 character database limits. Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads

DOUG, Saving the day AGAIN! Now I can relax and head to Leap to soak up even more knowledge!

My pleasure Heather -- see you next week! Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads

Hi Doug, thanks for your response, I had a feeling this was the case. I believed it would be possible to pull two milestone dates and display the difference; since I was able to use the add() function to a single milestone displayname=MC DUE +2weeks G0 listdelimiter= < div > listmethod=nested(tasks).lists textmode=true type=iterate valueexpression=IF({milestone}.{ID}="57b32d6d0065003c0a783e6533bd7c0c",ADDDAYS({plannedCompletionDate},14),"") valueformat=HTML "https://store.atappstore.com/product/ubercalc/">Uber Calc sounds good at this point of my report capabilities! Thanks again for your help! Kind regards, - Joe Joe Salas Logitech International SA

Just took this one step further with something I learned in a session this morning... Used the double pipe character to say OR: IF({teamID}="Team A" || {teamID}="Team B", IF({status}="NEW","New",...,status), ... ) So exciting to learn!