👋 Welcome! Introduce yourself and connect with your peers in Education to receive your industry badge.

Link Columns to another sheet dependent on answer to question

edited 05/16/24 in Education

For all exams listed on our Assessment sheet , if no incidents during the exam occur, is there a way to streamline by cross-referencing the Assessment sheet to populate specific columns in the incident report sheet instead of completing a separate report?

I'd like a user to go into the assessment sheet, scroll to the appropriate row's exam date/time and click a box "No incidents". This would copy the necessary columns for that exam into the Incident Report sheet without manually filling out the form that would have the same details.