Weekly Attendance Sheet

One row per person per week with a Monday-to-Friday grid, so days present and weekly attendance rate calculate themselves.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Education

Tables

Weekly register

Fields

12

Views

grid, dashboard

Tables, columns and sample rows

The table in this template, with its real columns, field types and sample rows. Copy the template to edit it in Edesy Tables.

Weekly register

12 fields · 7 sample rows

  • This week (Grid)
  • By group (Grid)
  • Overview (Dashboard)
NameTextGroupSingle selectWeek ofDateMonSingle selectTueSingle selectWedSingle selectThuSingle selectFriSingle selectDays presentFormulaDays markedFormulaWeekly %FormulaNotesText
Aditi RaoClass 4B12 Nov 2026PresentPresentPresentLatePresent55100%
Oliver GrantClass 4B12 Nov 2026PresentAbsentAbsentPresentPresent3560%Flu Tue–Wed
Rohan GuptaClass 4B12 Nov 2026ExcusedPresentPresentPresentPresent4580%
Amara OkekeAfter-school programme12 Nov 2026PresentPresentLatePresentAbsent4580%
Aditi RaoClass 4B19 Nov 2026PresentPresent22100%
Oliver GrantClass 4B19 Nov 2026PresentLate22100%
Neha SaxenaFront office19 Nov 2026PresentPresent22100%
Field details
Name · Text
Group · Single select
Class 4B, After-school programme, Front office
Week of · Date
Mon · Single select
Present, Absent, Late, Excused
Tue · Single select
Present, Absent, Late, Excused
Wed · Single select
Present, Absent, Late, Excused
Thu · Single select
Present, Absent, Late, Excused
Fri · Single select
Present, Absent, Late, Excused
Days present · Formula
IF(OR({Mon} = 'Present', {Mon} = 'Late'), 1, 0) + IF(OR({Tue} = 'Present', {Tue} = 'Late'), 1, 0) + IF(OR({Wed} = 'Present', {Wed} = 'Late'), 1, 0) + IF(OR({Thu} = 'Present', {Thu} = 'Late'), 1, 0) + IF(OR({Fri} = 'Present', {Fri} = 'Late'), 1, 0)
Days marked · Formula
IF({Mon}, 1, 0) + IF({Tue}, 1, 0) + IF({Wed}, 1, 0) + IF({Thu}, 1, 0) + IF({Fri}, 1, 0)
Weekly % · Formula
IF({Days marked} > 0, {Days present} / {Days marked}, BLANK())
Notes · Text

Weekly Attendance Sheet: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates