Coronavirus Monitoring Sheet

Contact-tracing for an organisation: log confirmed cases, trace their close contacts and monitor isolation and quarantine end dates.

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

Trackers

Tables

Cases, Contacts

Fields

23

Views

grid, kanban, calendar, dashboard

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Cases

12 fields · 3 sample rows

  • Cases (Grid)
  • By status (Kanban)
Case IDTextPersonTextAgeNumberPhonePhoneSite / unitSingle selectSymptom onsetDateTest dateDateStatusSingle selectIsolation endsFormulaContactsLink to another tableContacts tracedCountNotesLong text
C-001Rohan Das34+91 98300 11223Head office16 Nov 202618 Nov 2026Isolating23 Nov 2026Ankita Das, Vivek Sharma, Nora Smith3
C-002Grace Wong52+91 99000 33445Factory floor7 Nov 20268 Nov 2026Recovered14 Nov 2026Ravi Kulkarni1
C-003Mahesh Patil67+91 98220 55667Hostel14 Nov 202615 Nov 2026Hospitalised21 Nov 2026Sunita Patil1Admitted to City Hospital; family informed.
Field details
Case ID · Text
Person · Text
Age · Number
Phone · Phone
Site / unit · Single select
Head office, Factory floor, Hostel, Campus
Symptom onset · Date
Test date · Date
Status · Single select
Isolating, Hospitalised, Recovered
Isolation ends · Formula
IF({Symptom onset}, DATEADD({Symptom onset}, 7, 'days'), IF({Test date}, DATEADD({Test date}, 7, 'days'), BLANK()))
Contacts · Link to another table
Links to Contacts
Contacts traced · Count
Notes · Long text

Contacts

11 fields · 5 sample rows

  • All contacts (Grid)
  • Follow-up board (Kanban)
  • Exposure calendar (Calendar)
  • Outbreak summary (Dashboard)
ContactTextCaseLink to another tablePhonePhoneExposure dateDateExposure settingSingle selectQuarantine untilFormulaDays leftFormulaSymptomaticCheckboxTest resultSingle selectStatusSingle selectLast check-inDate
Ankita DasC-001+91 98300 1122417 Nov 2026Household27 Nov 20268AwaitingMonitoring19 Nov 2026
Vivek SharmaC-001+91 98300 2211015 Nov 2026Workplace25 Nov 20266NegativeMonitoring18 Nov 2026
Nora SmithC-001+91 98300 9988115 Nov 2026Canteen25 Nov 20266Not testedUnreachable
Ravi KulkarniC-002+91 99000 334467 Nov 2026Workplace17 Nov 20260NegativeCleared17 Nov 2026
Sunita PatilC-003+91 98220 5566814 Nov 2026Household24 Nov 20265YesPositiveBecame a case19 Nov 2026
Field details
Contact · Text
Case · Link to another table
Links to Cases
Phone · Phone
Exposure date · Date
Exposure setting · Single select
Household, Workplace, Canteen, Transport, Social
Quarantine until · Formula
IF({Exposure date}, DATEADD({Exposure date}, 10, 'days'), BLANK())
Days left · Formula
IF({Exposure date}, MAX(0, DATETIME_DIFF({Quarantine until}, TODAY(), 'days')), BLANK())
Symptomatic · Checkbox
Test result · Single select
Not tested, Negative, Positive, Awaiting
Status · Single select
Monitoring, Cleared, Became a case, Unreachable
Last check-in · Date

Coronavirus Monitoring 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