Discussions

Expand all | Collapse all

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

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

    Posted 9 days ago
    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
    ------------------------------


  • 2.  RE: Calculate End Date based on Term Selection (drop-down multiple choice)

    Posted 9 days 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
    ------------------------------



  • 3.  RE: Calculate End Date based on Term Selection (drop-down multiple choice)

    Posted 8 days 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
    ------------------------------