Forum Discussion

CeciliaMullan's avatar
CeciliaMullan
Qrew Trainee
6 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

2 Replies

    • CeciliaMullan's avatar
      CeciliaMullan
      Qrew Trainee
      6 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
      ------------------------------