WORKBOOK TROUBLESHOOTING
Check the inputs
before the formulas.
Work in a copy. If you need help, describe the issue with fictional or redacted examples rather than sharing a real roster.
A confirmed person is not counted
Compare Coverage and Volunteers: Service / room, Role, Start time and Sunday date must match exactly. Check the assignment is Confirmed and its Integrity flag is OK. Text that looks like a date or time may not be stored as the matching date/time value. Re-enter the values consistently in your working copy.
I see Missing input
Check the selected Sunday date in Coverage B4 and the role’s required inputs. On Volunteers, each populated assignment needs the person, service/room, role, status, date and start time. Unused blank rows can show Missing input; don’t fill them with invented data.
I see Time conflict or a duplicate is not counted
The same person entered at the same date and start time can be flagged across roles or rooms. Review the duplicate or competing assignment; conflicting rows do not count toward coverage. Different-start-time overlap is not detected because assignments have no end-time field.
There are enough names, but the gap is still open
Pending is not Confirmed. Cancelled and Declined do not count as confirmed. Extra confirmed people in another role cannot offset this role’s gap. Review the open role on its own.
The Example tab displays decimal start times
The current v1.0.1 download contains the corrected Example start-time values and displays 9:00 AM and 10:30 AM.
If your older v1 copy shows long decimals in those four cells, do not copy those values into working assignments. Type your intended start times directly in the blank Coverage and Volunteers tabs and match them exactly, or use your Payhip receipt to download the current version. Copies already saved on your computer do not update automatically.
The Example tab is a static reference and does not feed the coverage formulas. Find your purchased files, or contact COL if you need help with your version.
A formula was overwritten
Keep your edited copy for reference and open a fresh copy from your original download. Re-enter only permitted input data. Do not paste an entire row over the formula columns. If you no longer have the original, follow the purchase-download instructions.
The workbook will not open or looks different in another app
Download and extract the ZIP first, then open COL_Sunday_Coverage.xlsx in Excel on a computer. Don’t disable software security protections. Google Sheets import is not verified. If the problem remains, send COL the file name, application/version and error wording without private information.