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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!