iDoceo 8 for iPhone,iPad and Mac now available!

You will find all the details explained here
Welcome, Guest
Username: Password: Remember me

TOPIC: Count columns in a category

Count columns in a category 1 year 6 months ago #9648


Is there a way to count how many columns there are in a folder/category?

I currently have a gradebook set up with google classroom linked and grades imported.
Where a student has not completed a task, I have entered a cross icon (❌).
The grade book is split into folders for each term, and a calculation used to give an overall outcome for the term.

At the minute, the calculation counts how many crosses a student has received, and then returns 1️⃣/2️⃣/3️⃣ depending on this. At the minute, if I add a column to the folder, I have to go in and edit the formula to change the boundaries of how many crosse will output 3️⃣ etc

I would like this to be a rolling function where it automatically updates if I add additional columns. So rather than me having to work out how many crosses are allowed, it will automatically calculate this value based on how many columns/tasks were set.

When I couldn’t do this directly, I thought about possibly using two calculations?
One calculation to count how many columns (which would automatically update when more are added).
Then the folder calculation which would link to this and gives the final output.


A term has 5 tasks set,
0 or 1 missing tasks returns 1️⃣
2 or 3 missing tasks returns 2️⃣
4 or 5 missing tasks returns 3️⃣

If more tasks were set, these boundaries would change and I have to calculate and edit the formula individually.
I’d like it to stay at a constant 1/3, depending on how many tasks were set in total.
<33% missed tasks = 1️⃣
<67 % missed task = 2️⃣
>_67% missed tasks = 3️⃣

The administrator has disabled public write access.

Count columns in a category 1 year 6 months ago #9652

  • Ruislip
  • Ruislip's Avatar
  • Admin
  • Posts: 75
  • Thank you received: 23

I think I can help you with that.
Send me please a template of this class to karla @

The administrator has disabled public write access.
Time to create page: 0.110 seconds
21 AUG

iDoceo 7 for iPad and Mac now available!

A huge update with tons of new features and a new interface

Read more


Create Multiple-choice tests with iDoceo Connect!

In addition to self-evaluation rubrics, your students can now fill exams online. Supports text and images - in answers and questions - and can easily be imported from an XLS template

Read more

Cookies policy

This website uses cookies to make it easier for you to use the forum. We do not track you for any kind of advertising or statistics. Cookies are only used to keep you logged in the forum in case you would like to post and to keep your language selection in case you use the automatic translation offered by Google. If you continue to use our offer and have activated this technology in your browser, you consent to the use of cookies.