Date Add Formula

Question

Our&nbsp; 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.&nbsp;

I feel like I'm close with the following.
IF([Status]="100% Closed Won") WeekdayAdd([Arrival Date], [Quoted Lead Time])------------------------------Justin Olsen------------------------------

markshnier__you · Answer

try this

IF([Status]="100% Closed Won",&nbsp; WeekdayAdd([Arrival Date], [Quoted Lead Time])------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

justinolsen · Answer

That was almost it, it was just expecting another parenthesis on the end but thank you for helping I see what I did wrong!------------------------------Justin Olsen------------------------------

Forum Discussion

Date Add Formula