Skip to main content
Question

Help on Formula Error with Numeric vs Boolean

  • November 6, 2020
  • 0 replies
  • 171 views

Forum|alt.badge.img+7
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Can 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
------------------------------