Title Vote Sum Last Activity Created "https://support.workfront.com/hc/en-us/community/posts/360005435774-Enable-Reporting-on-the-Project-User-Object">Enable Reporting on the Project User Object 4 Monday at 10:33 Monday at 10:33 "https://support.workfront.com/hc/en-us/com...

Don't forget that all functions such as DATEDIFF have to be in capital letters. Capitalization is key in Text Mode $$TODAY, $$USER, $$NOW are always capitalized $$TODAYbw-1 - modifiers are lower case -- Melinda Layten, Senior Consultant Work Management Improvement CapabilitySource Phone: (484) 505-6...

There are two ways you can do this. If you always need the grandparent information you can add a second parent to a column. So select a key field from the parent information in standard mode and convert to text mode. So here is the parent:name field converted to text mode: valuefield=parent:name que...

You can replace the $$USER.roles with specific role ID(s) separated by tabs. -- Melinda Layten, Senior Consultant Work Management Improvement CapabilitySource Phone: (484) 505-6855 site: www.capabilitysource.com email: melinda.layten@capabilitysource.com Helpful? Buy me a coffee: https://www.patreon...

OK, crazy exists mode syntax (because I had this same problem today) Task Report for Tasks with Cross Project SuccessorsFilter:EXISTS:a:$$EXISTSMOD=EXISTSEXISTS:a:$$OBJCODE=PREDEXISTS:a:isCP=trueEXISTS:a:predecessorID=FIELD:ID Successor Project: Task Column:(remove spaces from the < p > )displaynam...

https://support.workfront.com/hc/en-us/community/posts/115001941888-Single-Sign-On-Add-Nickname-Field When you auto-provision or map fields in SSO it overwrites the user's preferred name with the system name. We all have our Michael's who go by Mike and Nicole that go by Nikki. Please let us have bo...

ROUND(DIV({actualWorkRequired},{workRequired})*100,1) Would give you 90.1% for example. Round is the number of decimal places to include and actually can be negative to round to the tens place for example. -- Melinda Layten, Senior Consultant Work Management Improvement CapabilitySource Phone: (484)...

Upvoted! I love to right align financials and the headings are then out of alignment and sloppy. This should be an easy fix. -- Melinda Layten, Senior Consultant Work Management Improvement CapabilitySource Phone: (484) 505-6855 site: www.capabilitysource.com email: melinda.layten@capabilitysource.c...

This means that you removed a choice from a selection field that was driving display logic elsewhere on the form or a selection field itself that was driving logic Look at your display logic calculations and you'll see a blank value somewhere. Remove the whole line, exit the field and go back in and...

And you can combine this with other filters EXISTS:a:$$EXISTSMOD=EXISTS EXISTS:a:$$OBJCODE=ASSGN EXISTS:a:assignedToID_Mod=isblank EXISTS:a:roleID=58bdc087000775373be69ebe12a1df11 EXISTS:a:taskID=FIELD:ID project:statusEquatesWith=CUR project:statusEquatesWith_Mod=in And last one for the cr...