Thanks so much!  that worked perfectly!  

yeah.. i've tried a few ways and i still can't get it to work.when i use it in the filter i receive this error I have been successful in creating a column in the report with the data.  but can't seem to get this to work in the filter. I have tried both lastNote:owner:homeGroupID     and lastNote:own...

I have a Projects report that shows the last made comment on a Project. I would like to show only comments that were NOT made by one specific group of people, SUPPORT.  The report is set up to show comments if the notes is not blank and if the project was updated last by not SUPPORT.But this may sti...

I need a Task report that will show Tasks based on Team assigned and also filter these based on what teams they are assigned to. I have tried switching to Text Mode and usingbut this doesn't seem to work.. Any other suggestions?teamID=584eb74d000c3804ef0731eee0fa5711teamID_Mod=inAND:teamID=$$USER.te...

When can we expect to see more updates with the Canvas Dashboards.  We have started utilizing them however I cannot add them to a users Layout Template.  This is problematic when dealing with large teams that all utilize the same Dashboards.

As a Manager of a team of users I would like a way to view the addition or removal of a custom form and by whom on a Job, Project or Request in the Update feed similar to when we track custom form fields.Having a team of 30 people and utilizing many different custom forms for specific jobs it is hel...

this was perfect.. appreciate the reply!

I am wanting to pull in some user data on custom forms for a new request that is then converted to a Project. I would like to pull in the Request Entered By name - All I can find is the {enteredByID} field however utilizing the .{name} after it results in an invalid custom expression.  Is there any ...

Thanks.  I was hoping there would be a simpler way but from all that i can tell I think the IF calculation is correct.  Maybe someday there will be an easier way to do lookups like this in Workfront.   

I'm trying to use CONCAT to pull together multiple drop down sections into a Field name in order to look up a price.  Have any of you been able to use CONCAT to generate a calculated field that will then display a different Form Field?   ExampleCONCAT("{DE:",{DE:Tier},"-",{DE:Level},"}")Creates: {DE...