Our fields have various stages for the status (0%, 30%,... 100%). We also have fields for arrival date and quoted lead times that get added together to populate a promise date.
What I want to do is when the order is set to 100% Closed Won (from the drop down option on the form) AND and arrival date is populated the quoted lead time is then added to the arrival date to generate a promise date.
I feel like I'm close with the following.
IF([Status]="100% Closed Won") WeekdayAdd([Arrival Date], [Quoted Lead Time])
------------------------------
Justin Olsen
------------------------------
