ContributionsMost RecentMost LikesSolutionsRe: Calculating the ""most"" used text answer or average of all text-multiple choice answersYay that worked! Also, how would I change the formula to keep the field blank if there are no related Workstream Status Records?Re: Calculating the ""most"" used text answer or average of all text-multiple choice answers Re: Calculating the ""most"" used text answer or average of all text-multiple choice answers var Number Max = Max([Total Green Workstream Status], [Total Yellow Workstream Status], [Total Red Workstream Status]) Case($Max, [Total Green Workstream Status], "Green", [Total Yellow Workstream Status], "Yellow", [Total Red Workstream Status], "Red") Re: Calculating the ""most"" used text answer or average of all text-multiple choice answers Re: Calculating the ""most"" used text answer or average of all text-multiple choice answersHi 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?Re: Calculating the ""most"" used text answer or average of all text-multiple choice answersHi, I have just a couple questions on this: 1. Is this all one formula? 2. What does the "var number" mean above? 3. #green, does this need to be the #FieldNameofTotalGreen? 4. Field Type is: Formula - Rich Text, correct? Thanks! AylinRe: Calculating the ""most"" used text answer or average of all text-multiple choice answersI fixed the summary fields! I didn't change the first section to a specific field, that's where I messed up.Re: Calculating the ""most"" used text answer or average of all text-multiple choice answersI actually think I did the Summary field incorrectly because of what I choose for the "Total of" part of the summary field. I think it's wrong because the total of the records on the screen shot says 6 and not 3. Please advise. Re: Calculating the ""most"" used text answer or average of all text-multiple choice answersHi QuickBase Coach, Could you please provide me with the formula as well? I will work on the summary fields first. Thanks, Aylin Calculating the ""most"" used text answer or average of all text-multiple choice answersI 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 overall status. For example out of 5 tasks 2 are yellow, 1 is red and 3 are green, so the overall status of the deliverable to describe the tasks would equal GREEN.