Forum Discussion

ArtArt's avatar
ArtArt
Qrew Trainee
7 years ago

Subtracting Different amount of days based on what option is chosen in two different fields

I have a Due Date Field, in which I want it to look at the Item Type Field, and Task Field and based on what is chosen it will calculate a Due Date.  I started typing this Date Formula but this field ...
Forms
Laura_Thacker's avatar
Laura_Thacker
Qrew Captain
7 years ago
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])))))