Forum Discussion

AylinNazlim's avatar
AylinNazlim
Qrew Cadet
7 years ago

Calculating the ""most"" used text answer or average of all text-multiple choice answers

I have child "Task" records that each have a status assigned to the record. I want to calculate the overall status of the Parent "Deliverable" to give an idea of where all the sub tasks level in an ov...
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
np
You would make a summary field on the Parent to total up the # of Greens, # of Yellows and # of red, in three separate fields.

Then make a formula to calculate the average Task Status.

Post back if you need help with the formula.