Forum Discussion
MarkShnier__You
Qrew Legend
5 years agoCan you tell us what field type [Property - Luxury House Plan] is? Is it a checkbox field type?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
JoshCollins
5 years agoQrew Assistant Captain
Hey Mark, yes [Property - Luxury House Plan] is a checkbox field.
------------------------------
Josh Collins
------------------------------
------------------------------
Josh Collins
------------------------------
- MarkShnier__You5 years ago
Qrew Legend
OK, I see the problem but it's not so much the syntax as the logic that is incorrect. If this does not give you the result you want, hen i will need to you express your logic in words, and thrn i can try to help with the formula.
I think what you want is this,
If (
// if Luxury = true, then result is at least 180
[Property - Luxury House Plan] = true, Max(180, 180 + ([Property - Total Heated SqFt]-3500)/50),
[Property - Luxury House Plan] = false and [Property - Plan - 2 Year Average Days to Build] < 113,
[Property - Plan - 2 Year Average Days to Build],
113 + ([Property - Total Heated SqFt]-113)/50)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- JoshCollins5 years agoQrew Assistant CaptainThanks Mark, that is working perfectly!
------------------------------
Josh Collins
------------------------------