This is great. I'm trying to do something similar except filtering to a date that's "greater than" another, which I got to work using your example. Do you know if there's a way to add "greater than" the other date + 5 days? So in your example, the planned start start greater than date requested +5 d...

@Sven-iX @RandyRoberts  Thank you both for your suggestions, but they did not work. Sven, would you mind writing out the entire valueexpression for me and I can try again? I might be a little confused there as text mode isn't my expertise. @Sheri_Whitten this is what I am running in to and trying to...

I have a custom form within a task for users to fill out a deploy date and time for emails. I am looking for a way to show this value on a task report for the next task which is to deploy the email. I would like to show this value in the column of the report, but there is no option. However, there i...

Hello, I would like to add a task within our projects that closes 10-15 min after the handoff date. I tried experimenting with the task constraints and tracking mode, but it doesn't seem to work properly. I believe these go off the planned completion date which doesn't take account for tasks that cl...

Hi, you can use text mode when adding a column to show the names instead of id's on a task level report. Project Owner displayname=Project Ownerlinkedname=projectnamekey=view.relatedcolumnnamekeyargkey.0=projectnamekeyargkey.1=owner:namequerysort=project:owner:nametextmode=truevaluefield=project:own...

Hello,   I'm trying to create a calculated field on a task level report adding the handoff date + the duration with the answer being the date and time of day. I cannot use projected completion date since it moves each day the task is not started.   This is what I have so far, however, the calculatio...

Bumping this thread. Any suggestions?

I came up with the below calculation which seems to work, but when my duration has a decimal (.5 days, 1.5 days) the calculation doesn't notice the .5, it rounds down to day.  Example: Handoff date - 12/19 10 am Duration - 1.5 days Calculation -  12/20 10 am   Thoughts on how I get the system to not...

Hello, I'm looking to create a calculated field on a task report.   I would like the calculation to be task handoff date + task duration and the result to show in date and time format.    I cant seem to find a field that gives me this without the dates moving to the next business day if a task is la...