Hi Community, I have a situation that call for a Document or Document Version report, but I also need the report to show all the tasks in a project, including those that don't have a document attached yet.  

Hi all, due to a reorg my current position as a Workfront Admin has been eliminated.  If you have any leads on remote positions please let me know.  My email is ajdifonzo@gmail.com and my LinkedIn profile is  linkedin.com/in/alexdifonzo/  Thanks in advance

For those that bill the hours entered on a project, how do you handle when a resource works overtime on the project to get the actual cost of those hours on the project? For example - if an hourly resource with a cost of $20.00 / Hour works 10 hours on a project, with 2 of those hours being overtime...

I’m working in an Hour report and have two calculated columns, one for “Billable Hours” as followsaggregator.displayformat=doubleAsDoubleaggregator.function=SUMaggregator.namekey=hour.pluralaggregator.valueexpression=IF({hourType}.{countAsRevenue}=true,{hours},"")aggregator.valueformat=doubleAsDoubl...

This should do it.  valueexpression=LEFT({DE:Please tell us what you would like},150)

please provide the original text for the column so I can take a look. 

Hi, You can use the following to limit what is show. Since you noted the description field that is what I used.  The 25 would be the number of characters you would like to show.  valueexpression=LEFT({description},25) If this helps, please mark as correct so it can help others. 

Hi Madalyn,  I have to give credit to @Doug_Den_Hoed__AtAppStore   for this one that I have saved.  This is not an hour report, but a user report with the following to that will return any Users with no hours entered in the past 7 days (for example): EXISTS:a:$$EXISTSMOD=NOTEXISTSEXISTS:a:$$OBJCODE=...

This should work for you, in my example I am using a field that is in my system and below that the same text with your field. I changed "valuefield" to "valueexpression" and used brackets.  displayname=Asset Typetextmode=truevalueexpression={document}.{project}.{DE:MCS - Project Type}valueformat=HTM...

Hi JH48,  here is one option to show only proofs that checks for the proofID.  displayname=Documents and Proof Statuslistdelimiter=<br>listmethod=nested(documents).liststextmode=truetype=iteratevalueexpression=IF(ISBLANK({currentVersion}.{proofID}),"",CONCAT({name}," - ",{currentVersion}.{proofDecis...