Formula to summarise folder information

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

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