Discussions

Expand all | Collapse all

formula checkbox help needed

  • 1.  formula checkbox help needed

    Posted 08-31-2018 17:18
    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? 


  • 2.  RE: formula checkbox help needed

    Posted 08-31-2018 17:28
    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.


  • 3.  RE: formula checkbox help needed

    Bronze
    Contributor
    Posted 08-31-2018 23:22
    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")