Forum Discussion

JustinOlsen's avatar
JustinOlsen
Qrew Member
2 months ago

Date Add Formula

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
------------------------------

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    2 months ago

    try this

    IF([Status]="100% Closed Won",  WeekdayAdd([Arrival Date], [Quoted Lead Time])



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • JustinOlsen's avatar
      JustinOlsen
      Qrew Member
      2 months ago

      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
      ------------------------------