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
Actually, here isa format for a formula

var number Max = Max([# green], [# yellow], [#red])

Case($Max,
[#green], "Green",
[#yellow], "Yellow",
[#red], "Red")
AylinNazlim's avatar
AylinNazlim
Qrew Cadet
7 years ago
Hi I'm almost there!
1. I'm getting this error message for the first "MAX" shown below. What does MAX refer to?


2. Just to take this one step ahead while we are talking about it. I will also like to average the formula of the Average Task Statuses to the related parent record, would I make a formula-text field on the parent table for the Averaged child records of the Grand child records?