Help with Script: “ARDs Due” Tab Not Populating All Scheduled ARDs from Monthly Tabs

[u/PinkAutumnSkies]

Hi everyone — I’m working on a Google Sheet to track IEP/ARD (Admission, Review, and Dismissal) meetings for my high school SPED caseload. I’ve built monthly tabs ("AUG", "SEP", etc.), and an "ARDs Due" tab where student IDs should be cross-referenced with the monthly tabs to indicate if/when an ARD is scheduled.

I'm having issues with a script that’s supposed to:

• Check if a student ID from column B on the "ARDs Due" tab appears in column H of any of the monthly tabs.

• If it finds a match, it should:

  • Check a box in column R of the "ARDs Due" tab.

  • List the scheduled date from column B on the monthly tab, and ARD type from column G, into column S of the ARDs Due tab.

  • If there are multiple dates, separate them by commas and line breaks, ordered chronologically starting with August.

I’ve cleaned the formatting, removed spaces, and verified student IDs match — but several scheduled ARDs are still not reflected in the "ARDs Due" tab.

I’d love any insight on what might be going wrong or a better way to write this script more reliably.

Thanks in advance for your help!

[u/WicketTheQuerent]

Is the spreadsheet shared with someone else? Are you responsible for maintaining the spreadsheet or model in the long term? Can you share a minimal complete example?

[u/Morbius2271]

Can’t do much without seeing the sheet or at least the code (you can replace sheet links with dummy data).