Use the website formula to analyze data

[EduSnip_Trailblazer2]

Okay, I have a crazy idea, and I'm not sure if TB can make it happen. I review my students' gradebooks every day before texting them what their next assignment should be. With 160 students, this takes up a lot of time. I wanted to see if there was a way for TB to read the data on a website and then, using formulas, return the information that I am looking for.

Here is the gist of it. I created a table and I am going down the line and adding the information I need for each of the 60 assignments that students are required to complete. It looks like this:

Side note: if there is an easier way to retrieve this information from the website, let me know.

This is what it looks like once the system reads it:

Here is what I would need the formulas to do:

Formula #1: Goal: return the name of the next assignment due that has not been exempted.
Essentially, I need the formula to go down the list to each row in the "C: submission date" and find the next row that says "N/A" where the column score does not include "ex" in it. This would mean that the student has not completed this assignment, and the assignment is not exempted, so this would be the next assignment they would need to complete. In the previous example, that would be "02.02 Gathering and Check Your Information". Although 01.10 is the first "N/A' on the list, the formula would ignore this one because the score includes "ex" in it.

Formula #2: Goal: Identify if a student is skipping
The formula would need to be able to identify if there have been assignments submitted after the next available "N/A" assignment. For the example given, the student has submitted 02.03 and not 02.02 because 02.03 has a score. This means that the student has skipped an assignment.

Formula #3: Goal: Identify when a specific assignment is due.
The formula would identify the name of the next assignment due, but when that assignment name includes the words "Discussion-Based Assessment" the formula would instead of returning the name of the assignment would return the phrase: "DBA Needed"

Formula #4: Goal: Return the names of the assignments completed the previous week.
The formula would need to read the dates in column C and return the assignment name of any assignment that was completed the previous week, Monday-Sunday.

Lastly, when returning the name of the assignment, I only want the numbers, not the words or the initial zero.

In this example, the formulas should return:

Next Assignment Due: 2.02
Assignments Submitted Last Week: None
Skipping: Yes

In this other example, the formulas should return:

Next Assignment Due: DBA Needed
Assignments Submitted Last Week: 4.02
Skipping: No

[Dan_Barak1]

Hi @EduSnip_Trailblazer2
This may be easier if you can read all the data using one selector and then split it into the table. Doing it this way will allow filtering and/or sorting the assignments, and those can be used to achieve your formulas.

Here's a simple example:

{selector_data="Score,Assignment Name,Submission Data\n13.00 / 20,01.01 The Plot Thickens,10/10/25; 2:16 PM\n43.00 / 50,01.02 Plotting It Out,10/14/25; 12:13 PM\n50.00 / 50,01.03 Making Connections,10/15/25; 12:54 PM\n10.00 / 16,01.04 What Does It Mean?,10/15/25; 1:02 PM\n30.00 / 30,01.05 Choose Your Words,10/23/25; 7:31 PM\n10.00 / 10,01.06 Implicit or Explicit Evidence,10/23/25; 8:02 PM\n10.00 / 10,01.07 What is the big idea?,10/23/25; 8:08 PM\n43.00 / 50,01.08 Getting the Big Picture Discussion-Based Assessment,10/17/25; 3:38 PM\n92.00 / 100,01.09 Getting the Big Picture Exam Global Password,11/19/25; 2:10 PM\n ex / 50,01.10 Advanced Poetry About People Honors,N/A\n6.00 / 10,02.01 Organize Ideas in Informational Writing,11/5/25; 3:07 PM\nin progress / 50,02.02 Gather and Check Your Information,N/A\n22.00 / 22,02.03 Cite Your Sources,11/5/25; 4:06 PM"}
{table=fromcsv(selector_data)}
{non_excluded=filter(table, x->NOT contains(lower(x.Score),"ex"))}
{not_scored=filter(non_excluded, x-> contains(lower(x["Submission Data"]),"n/a"))}
Next assignment: {=not_scored[1]}

Please email us at support@blaze.today and we can help you further.

[EduSnip_Trailblazer2]

Thanks for responding @Dan_Barak1! I am unfamiliar with using one selector. Our gradebooks look like this:

When I use the website selector to import the information, I can either do the entire chart:

or each box, which is the way I was originally doing it.

If I do the entire chart, the data looks like this:

I'm not sure how I would format the selector to read this data. Thank you so much for your help.

[Dan_Barak1]

Hi @EduSnip_Trailblazer2 ,
Please email us and let's jump on a call to work on this live.

Thanks,
Dan