Date checkboxes in sheet generated from a range of dates in another sheet

Beth C
Beth C ✭✭
edited 06/23/22 in Formulas and Functions


I have a grid that is filled by a Vacation Request form. Team members can request single dates only or a range of dates.

When the request is approved, I want to check each date in the request to individual checkboxes in another sheet like the "Beth" column below.

I would also like it to see single dates, like in the "Eric" row in the first picture. I would then use these checkboxes in an Index/Match formula in each person's individual schedule.

The formula that I currently have in the "Bryan" column pulls only the Start date.

=IFERROR(INDEX(COLLECT({Vacation Approved}, {Tech Name}, "Bryan", {Vacation Start}, Date@row), 1), 0)

Any help would be appreciated!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!