I see...thank you for the quick reply.

Hello,I have a report that is using collection to pull all issue entered for a project. An issue (with the same name) can be entered a couple times to link to other groups or assignments. Is there a way to group the same issue (name) within the text mode below to display as one rather than multiple ...

@NicholeVargas thank you so much! I was using CLEARTIME to bracket both {lastUpdateDate} and {entryDate}. Anyways, placing the CLEARTIME in both sides of the expression did help to tag each entry correctly.

Thanks @NicholeVargas 

Hi @skyehansen - Thank you for the suggestion. I just have not been able to get it to work and have taken a break from it. I may revisit this again in a couple weeks. If I still cannot get this to work, do you have any other suggestion on how to pull a collection of updates for an object? Example: a...

Hello. I am building a project report to count how many projects are created as new vs update to capture the trend over time. To determine what is new vs an update, I decided to create a custom column with an IF statement to compare the project Entry Date and Last Update Date.  Text Mode:displayname...

I found this calculated custom field on Workfront that display a field's edit history. This calculation adds the date after the update. I've been struggling for hours to try to move the timestamp before the update but with no success. I cannot seem to figure out where my error is at. Can someone ple...

I have a team that uses the issue tab in project to log in objectives and action items. There is a log type field created to tag whether an issue is an "objective" or "action item". I am trying to create a project report in Workfront that shows the total number of issues and number of open issues. H...

Ha! That CONCAT did the trick. Thank you @skyeh !

I have tried your recommendation to firs test the one IF statement : IF({DE:FIA_ImpactLevel}="Low Impact","2","") and it did not work. I'm not sure if I need to define a syntax before "Low Impact" since it is one of three options from DE:FIA_ImpactLevel field.