Pre-chosen date based upon name chosen


Hey all.

Is it possible to set template date(s) in a group of cells when another cell drop down is selected?

For instance, If I choose from a drop down "June 2024" the dates cells next to this would snap to certain dates (milestones) automatically. Trying to have x4 milestone dates snap when a "Month Year" is selected.

Can anyone help?

Many thanks in advance.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!