Skip to main content
Question

formula checkbox help needed

  • August 31, 2018
  • 0 replies
  • 62 views
I'm tracking when orders are received and i need a formula checkbox to check it self if the quantity of the product ordered is equal the sum of multiple numeric fields that are used to track the quantity of smaller shipments received. This was my first formula attempt that does not work: If([Quantity Ordered]=Sum([Quantity Received]+[Quantity of Remaining Items Received]),"yes,"No"). Does anyone have any better suggestions for me? 
    This topic has been closed for replies.

    • KevinSlider
    • Registered
    • August 31, 2018
    If([Quantity Ordered]=Sum([Quantity Received],[Quantity of Remaining Items Received]),"Yes,"No")

    I think the Sum function requires this format Sum(X,Y,Z)
    Let me know if that helps, using the comma delimiter.
    Slider is right about sum. Use commas, not +. Here's the page describing that function https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=134&rl=v9a

    Also, looks like you're missing a "

    If([Quantity Ordered]=Sum([Quantity Received],[Quantity of Remaining Items Received]),"Yes","No")
    Terms & ConditionsAccessibility statement