Is there a way to backdate project actual completion date in kickstart? When I try to import via kickstart it is setting acutal completion to today's date, despite filling in the columns setActualCompletionDate and setActualStartDate with the dates for setPlannedCompletionDate and setPlannedStartDat...

Yes, please. I'm fairly new to Workfront and I know I would find great use in a discussion group on expressions.

Thanks, this helped! Here's what I ended up with: IF(LEN(Title)>75,CONCAT(LEN(Title)," WARNING: Title exceeds 90 characters"),(LEN(Title)))

Hello, I'd like to be able to add an if then statement to check if the character count for a string is greater than a specified number, but my formula is not valid. This is what I have so far,... IF(LEN(field)>140,"over limit","under limit") The field I'm pointing to is a single line text fiel...