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.
 312 Points
Posted 4 months ago
QuickBaseCoach App Dev./Training, Champion
 62,550 Points
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.
 312 Points
Could you please provide me with the formula as well? I will work on the summary fields first.
Thanks,
Aylin
 312 Points
QuickBaseCoach App Dev./Training, Champion
 62,550 Points
QuickBaseCoach App Dev./Training, Champion
 62,550 Points
 312 Points
QuickBaseCoach App Dev./Training, Champion
 62,550 Points
var number Max = Max([# green], [# yellow], [#red])
Case($Max,
[#green], "Green",
[#yellow], "Yellow",
[#red], "Red")
 312 Points
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!
Aylin
QuickBaseCoach App Dev./Training, Champion
 62,550 Points
2. The var refers to a formula variable. it is a useful technique to make formulas more readable. Here is some help text. https://help.quickbase.com/userassistance/formula_variables.html
3. Yes, you would put in the name of your field for the total # of green.
4. The formula is formula text , not formula rich test.
 312 Points
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 formulatext field on the parent table for the Averaged child records of the Grand child records?
QuickBaseCoach App Dev./Training, Champion
 62,550 Points
We might have to rename the formula variable to call it "highest". Maybe Max is a reserved word.
The formula is using a formula variable just to increase the readability of the formula. https://help.quickbase.com/userassistance/formula_variables.html
As for your second question, I am not understanding your question. Can you explain with an example.
 312 Points
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")QuickBaseCoach App Dev./Training, Champion
 62,550 Points
var Number Max = Max([Total Green Workstream Status], [Total Yellow Workstream Status], [Total Red Workstream Status]);
 312 Points
QuickBaseCoach App Dev./Training, Champion
 62,550 Points
IF($Max > 0,
Case($Max,
[Total Green Workstream Status], "Green",
[Total Yellow Workstream Status], "Yellow",
[Total Red Workstream Status], "Red")If([PicExistsFull], "<a target='_blank' href=" & $URL & ">" & $Words & "</a>", " ")
)
be sure that the field properties of the the three Totals fields are set to treat blank as zero.
QuickBaseCoach App Dev./Training, Champion
 62,550 Points
I will also like to average the formula of the Average Task Statuses to the related parent record, would I make a formulatext field on the parent table for the Averaged child records of the Grand child records?
Related Categories

Formulas & functions
 2885 Conversations
 72 Followers