Forum Discussion
QuickBaseCoachD
Qrew Captain
Actually, here isa format for a formula
var number Max = Max([# green], [# yellow], [#red])
Case($Max,
[#green], "Green",
[#yellow], "Yellow",
[#red], "Red")
var number Max = Max([# green], [# yellow], [#red])
Case($Max,
[#green], "Green",
[#yellow], "Yellow",
[#red], "Red")
QuickBaseCoachD
6 years agoQrew Captain
Please post your code too as I cannot correct a screen shot. It looks like the formula variable is missing the last semi colon.
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/user-assistance/formula_variables.html
As for your second question, I am not understanding your question. Can you explain with an example.
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/user-assistance/formula_variables.html
As for your second question, I am not understanding your question. Can you explain with an example.