weighted averages from different columns

Hello. First time on the forum, so I hope that what I am about to ask makes sense, and someone can help me.

I have created a gradebook where I have a Folder (Responding) and within this folder I have 5 sub folders (Please see attached picture), And subsub folders within these. I have a formula within each of the sub folders that creates a value from the sub sub folder, and I get a score. Within the main (Responding) Folder, I have a formula that gives me a total from the sub folders. I now need to create a new column with the A-F grade, based on the value in the Responding Folder. However when I add a weighted average and select the folder it returns a 0 result. (Sorry this make much more sense in my head :silly: )

I am really hoping that someone can help me

Welcome Janinem,
When you have a chance, send me a template of that gradebook and I'll give it a look:
Export > Share > All tabs, no students.
Send it to support @ idoceo.net

Thank you, I will send it now. PS, I have started a new folder section called Making, This folder and contents can be ignored for now.

I am looking at the GTMJ Tab

Let's focus first on the formulas you are using. There is an easier way to configure it other than a formula. but let's keep them if you are familiar with that.

On this folder, Q1b and 1B. What kind of score do you have on each. Are they based on 100 points?

eventually I will be adding the Making folder, to get an overall grade from Responding 50% and Making 50%

if these were based on 100 points, that they would be 50 each

Ok, but with iDoceo you do not have to worry about assigning that weight in each folder with a formula. You only have to worry about assigning the score/grade type on each column and the weighting is done afterwards.
You could add a third category afterwards and all the folders inside would not need to be changed at all.

Let's keep focussing on this A blue folder.
Double tap on the header > Grade type > and set here the Numeric grade (Generic) and type
the max points that could be achieved with the formula.
Then in the same column properties > Quick conversion > A to F

Done, would I be correct in saying 100 for the max points?

It depends on what kind of scores you will be inserting in Q1b and 'Added responses in 1b'
This score is what iDoceo understands as 100% success.
If Q1b and 1b are only 10 points each for example, the 100% success would be 50 (as per your formula)
It is only a matter of knowing what kind of score/grade you will be using in your gradebook