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