Formula Help

My ultimate goal is to have a checkbox checked automatically.

I have two sheets...(Employee Staff Schedules) and (Schedule Compliance)

Each Friday employees provide their schedules through an Employee Staff Schedules Form. The Form includes the Employee Name, two date fields (Week Start Date) and (Week End Date) and then each day of the week of what shift they are working.

The Schedule Compliance Sheet contains the Employee Name and a Checkbox Column for every week.

I have been trying to Index/Match, but I keep getting an error. Come someone please provide me with a formula? Thank you!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!