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



Best Answer

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

    Hey @cocog,

    These two formulas should work for that


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

    On Order

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!