Hi Samantha, Could use the 'Reference Number' fields (vs. names) to compare the differences between the two numbers. If they are different then color the cell green.

If you are comparing a custom field, use DE:Actual Name of the Field for the name field you are comparing with the first field. Note:If you manually enter the name of a custom field by the same name as a Workfront native field, you must precede it in the calculation by "DE:" and surround it by cur...

Hello Workfront Community! I have made many attempts in Columns (View) | Text Mode | to create a report but had no success. The Task Report criteria is:IF the Task Due Date ends before the Project Due Date, turn the background red. Thank you for reading!Kind regards, - Joe

Hi Tami, I think the custom form fields may already be searchable using the advanced search page. ( I haven't tested by license type, I'm using admin access) See Attached image for number references 1. Use the Search form and enter the name of the field 2. Use Advanced Search 3. Select the Task / ob...

Happy Holidays Everyone! WFPro Tuesday Trivia looks fun, I received the All Discussions Digest for Wednesday December 11, 2019So this is a Wednesday Trivia Feedback response. Is the screenshot describing a record containing properties of a form field type?

This code works for to find custom form(s) featured in templates. Thank you all for posting questions, feedback and many thanks to Doug for code! Kind regards, - Joe P.S. does this giphy format work in this forum Joe Salas Logitech International SA

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(task...

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 ...

Hello Vic and Dustin, Thanks for your replies! Attached is a Diagram that outlines a report that I'm trying to create. It's basically a list of projects that display their milestone dates and describe the number of days between the dates. I understand the structure of database tables may restrict pu...

Hello Workfront Community! Is the following possible to accomplish in Workfront? I would like a project custom form field to reference and store the value of a task date in order to conduct a Custom Field Expression in a Project Report? The report calculation would basically minus the two dates from...