Ask for help for text mode calculation

[JerryWu]

Dear Friends

I'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 solution]

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.

[JerryWu]

Hi J_Mas, thanks for your help! It works, very helpful!