I'd like to create a series of formulas in a sheet that will automatically check a checkbox column if certain conditions exist. The 2 sheets are ATTENDANCE and SIGN IN. The Sign In sheet has attendee names in the first (non-Primary) column (in the order that the attendee signs in, not alphabetized) and has a date in…
Good afternoon. I have created a sheet with a form to capture reservation details for a live performance. There are 4 performance date options and form users identify their 1st-4th choices. Once received, they are assigned a date and the cell in the appropriate "Confirmed" column is marked YES. There are 4 "Confirmed"…
Good morning! I have 3 sheets that work together to serve various functions, including taking daily attendance. MASTER CAST LIST lists each person's name, SIGN IN SHEET and CONFLICT CALENDAR are driven by forms with contact formatted drop down lists. It's all the same people on each of the 3 sheets and the primary columns…