formula checkbox help needed

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • In Progress
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? 
Photo of Brian

Brian

  • 90 Points 75 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of Slider

Slider

  • 1,326 Points 1k badge 2x thumb
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")