Auto populate multiple checkboxes from 2 dates

Hello!


I am trying to auto populate multiple checkboxes from the anticipated start date and end date based on the fiscal years. For example the 10/5/21 to 4/30/22 would have Q2, Q3, and Q4 check marked. Is there some formula that would allow me to be able to automatically checkmark every quarter that is between those 2 dates.

Thank you!

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    I don't know exactly what your dates are for the quarters, so I will use Jan 1 - Mar 30 as Q1 in my example. You will need to change the dates to match your quarters.


    =IF(AND([Anticipated Start Date]@row <= DATE(2021, 03, 30), [Anticipated end Date]@row >= DATE(2021, 01, 01)), 1)


    The idea is if the [Anticipated Start Date] is less than the end of the quarter and the [Anticipated End Date] is greater than the start of the quarter.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!