displayname=Date Differencelinkedname=directtextmode=truevalueexpression=WEEKDAYDIFF(CLEARTIME({project}.{plannedStartDate}), CLEARTIME({plannedCompletionDate}))valueformat=HTMLFlipped the 2 bits and its working!! THANK YOU JUSTIN!!! 

displayname=Date Differencelinkedname=directvalueexpression=WEEKDAYDIFF(CLEARTIME({plannedCompletionDate}), CLEARTIME({project}.{plannedStartDate}))valueformat=HTMLHey Justin, thanks for getting back so quickly! Holidays i can live without as long as i can get the weekday. Applied the above text, bu...

Hi Justin! Thank you most kindly for this, its a great piece of text. Only issue i have is that its pulling calendar days, i was hoping to get business days. Maybe theres a calculation to put in,( to remove weekends) or a way of applying the schedule thats used for the project (which i think removes...

Hi folks. trying to make a column that works out the days a task finishes on from the start of a project and puts in a numerical value. So Project start date - 1/1Task A > Due Date =  1/20column says 19 days  Bit of a rubbish explanation i know. but if theres any way to do this calculation it would ...

Ok so i took a bunch from another report. Here is a final system to make backgrounds colour coded. Less than = green, Equals = yellow, Greater than = red. descriptionkey=durationMinutesdisplayname=durationunitfield=durationUnit.valuelinkedname=directlistsort=intAsInt(durationMinutes)namekey=duration...

HI Both thank you for these links!! Great work! Richard is there a way to make the Background Red instead of the text? going to play around and see if i can get it have a secondary comparison for Less than. Which im hoping will be similar syntax but with "lt"? and a diff colour. thanks both! 

HI Team! Trying to compare 2 Duration columns in a Task report. Original Duration (task)  VS. Duration (task) Both ive got in Days and i would really like it to give me a colour if the date in the Duration column is Greater than the days in the Original Duration column.  I have tried and failed with...

Hi folks. trying different options to see how often a project timeline is edited, see that i can pull a baseline report which DOES have a record count, when you group it by Project name. BUTTTTT I cannot figure out how to make a report that Groups by this count!?SO it would put all the projects with...

Hi folks, i want to put a report together on tasks that have their due dates changed. I want to show, what tasks are being changed, how many times they are changed, and the duration of the tasks. Ideally i would like to be able to compare directly against the template that the project was set up wit...

5.5 years and wish this were a readily available!