Forum Discussion
Laura_Thacker
7 years agoQrew Captain
Try this:
If([Item Type]="Proficiency Testing",
If([Task]="Video Jet", WeekdayAdd ([Due Date], -60),
If([Task]="Labels Applied", WeekdayAdd ([Due Date], -60),
If([Task]="Collating", WeekdayAdd ([Due Date], -50),
If([Task]="Dispensing / Gluing", WeekdayAdd ([Due Date], -40),
[Due Date])))))
If([Item Type]="Proficiency Testing",
If([Task]="Video Jet", WeekdayAdd ([Due Date], -60),
If([Task]="Labels Applied", WeekdayAdd ([Due Date], -60),
If([Task]="Collating", WeekdayAdd ([Due Date], -50),
If([Task]="Dispensing / Gluing", WeekdayAdd ([Due Date], -40),
[Due Date])))))