Counticon

More
3 years 2 months ago - 3 years 2 months ago #9602 by CBashford
Counticon was created by CBashford
Hi,

I’ve been trying to set up a calculation using the “if” and “counticon” functions, but am struggling to get a working formula.

I have my class linked to google classroom, and assignment marks are imported.
I have set a quick calculation to get the percentage/colour.
For any student who has not handed in the homework, I have added the cross icon (❌) .

I want to have a formula which counts how many crosses for each student, then returns a 1️⃣/2️⃣/3️⃣ depending on how many homework handed in (or in this case, how many are not handed in )

Thanks
Attachments:
Last edit: 3 years 2 months ago by CBashford.

Please Log in or Create an account to join the conversation.

More
3 years 2 months ago #9603 by CBashford
Replied by CBashford on topic Counticon


I believe I’ve found a work around.
Probably very convoluted and not needed, but does what I’m looking for currently.
It needs editing for each individual term/class, so that will be time consuming, and so I would still love any support/ideas for easier versions.

Thanks
Attachments:

Please Log in or Create an account to join the conversation.