Expand my Community achievements bar.

Join us for our Coffee Break Sweepstakes on July 16th! Come ask your questions or share your use cases on Creative Briefs for a chance to win a piece of Workfront swag!

Calculated Column

Avatar

Former Community Member
Hello, I have entered this into a column on a task report but it's not working: displayname=Age Since Entry Date textmode=true valueexpression=IF(status='CPL', WEEKDAYDIFF(actualStartDate, actualCompletionDate), (WEEKDAYDIFF(actualStartDate, $$NOW)) valueformat=HTML Would appreciate any help or advice. Thank you. Nadia Shakfeh IEHP
1 Reply

Avatar

Level 1
Please try this: valueexpression=IF(status='CPL', WEEKDAYDIFF({actualStartDate}, {actualCompletionDate}), WEEKDAYDIFF({actualStartDate}, $$TODAY)) Siva Addepally