👋 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
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.
Answers
-
Are you able to provide screenshots for context (sample data is fine).
-
The Assessment calendar shows all exams. I'd like a quick checkbox next to each row to indicate acknowledgment of "No Incidents" and then those certain details pulled from the Assessment Calendar (ie, exam name, date, etc.) appear on the Incident Report sheet without having to fill out the form (also included here) manually
-
My suggestion would be to just use a Copy Row automation and then hide the extra columns coming over from the calendar sheet that don't need to be on the incident sheet.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives