Ask for help for text mode calculation

Question

Dear FriendsI've a sample task report, I would like measure the sample performance, so I would set up formula between actual receive date VS actual send out date And the rule is:-if the actual send out date less than equal actual receive date + 4 weeks then it is "on time"if the actual send out date exceed actual receive date + 4 weeks then it is "Late" And My expression as below and doesn't work, could you take a look and correct formula below. Many thanks!valueexpression=IF({DE:Actual send out date}<={DE:Actual Receipt Date}+4w,"On Time","Late")

J_Mas · Accepted Answer

I think this would do it. It worked for me (substituting estStartDate and estCompletionDate for your custom dates).

displayname=On Time or Late
textmode=true
valueexpression=IF({DE:Actual send out date}<=(ADDWEEKDAYS({DE:Actual Receipt Date},20)),"On Time","Late")
valueformat=string

I use "ADDWEEKDAYS" and add 20 weekdays to get the equivalent of 4 weeks. As far as I know there's no formula in Workfront that adds weeks. Only days, weekdays, months, or years.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded