# formula checkbox help needed

• 0
• Question
• Updated 7 months ago
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?
• 130 Points Posted 7 months ago

• 0
• 1,386 Points 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.
• 2,592 Points 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")