Formula to summarise folder information

More
2 years 9 months ago #9827 by nickyengert
Formula to summarise folder information was created by nickyengert
Hi,
I have created a folder for several marking columns. The columns are imported with marks from Google Classroom.
I would like to create a calculation that provides a summary of whether all columns contain marks (giving a grade of 'Achieved'), only some do (giving a grade of 'working towards', or none do (giving a grade of 'not achieved').
I do have a set of grades set up (Achieved, Working Towards, Not Achieved)

Would really appreciate some assistance with the formula for this.

Thanks

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

More
2 years 9 months ago #9828 by bert
Replied by bert on topic Formula to summarise folder information
Hello,
The number of columns must be inserted manually at the moment in that formula so it wouldn't be a very practical configuration. Let me see if I can add a specific function to count those columns and I'll get back to you with a Beta version
The following user(s) said Thank You: nickyengert

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