Discussions

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

    Posted 05-21-2020 19:43
    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 05-21-2020 19:58
    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 05-22-2020 15:48
    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
    ------------------------------