Formula in a dropdown menu

This is what I am trying to do...

I need the total of "amount Due" if "invoice" is selected. And the Total of "Amount Due" if "On Order" is selected. I would like for that info to populate at the top

Help!


Tags:

Best Answer

  • Devin Lee
    Devin Lee ✭✭✭✭✭
    Answer ✓

    Hey @cocog,


    These two formulas should work for that

    Invoiced

    =SUMIF([PO Status]:[PO Status], "Invoiced", [Amount Due]:[Amount Due])
    

    On Order

    =SUMIF([PO Status]:[PO Status], "On Order", [Amount Due]:[Amount Due])
    

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!