Forum Discussion

CeciliaMullan's avatar
CeciliaMullan
Qrew Trainee
5 years ago

Calculate End Date based on Term Selection (drop-down multiple choice)

Would it be possible to have a field automatically populate the End Date of a project based on the selection of a Start Date (Date Field) and a Term (multiple choice drop-down field, e.g., 6 months, 3 months, etc.)? 
 
Thank you!

------------------------------
Cecilia Mullan
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    Yes, can you tell us your exact drop own choices?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • CeciliaMullan's avatar
      CeciliaMullan
      Qrew Trainee
      5 years ago
      Thank you! I actually figured something out. I created a numeric input field for the number of months (since they can vary considerably across projects)  and then created a formula for my end date field that adds the number of months from the start date field.

      ------------------------------
      Cecilia Mullan
      ------------------------------