Hello,
I've written the formula below and in the screenshot. Basically, If (this & that) is true, then (result 1), otherwise, result 2.)
Quick Base is telling me that it is "Expecting a Boolean but found Number" for the result 2 formula. I'm not sure why.
Could anyone diagnose this for me?
I've attached a screenshot of the formula and also the error message when saving.
Here is the formula:
If (
[Property - Luxury House Plan] = true and (180+(([Property - Total Heated SqFt]-3500)/50))<180, 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))
)
Thanks in advance!
------------------------------
Josh Collins
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.