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. 

Hello, I am trying to add a rating column based on the impact level on an issue report. I have created an IF statement for the column in text mode to look at the level and assign a number, but it doesn't seem to work. I am not sure if my IF statement format is incorrect, or if there is a better way ...