#Incorrect Argument Set

Options

Good Morning,

I've been trying to figure this formula out but I can't seem to get it. I need to sum any amount in the computed count column, match it with the AP tech for a specific month. I've tried swapping the columns around but nothing seems to work. What am I missing?

=SUMIFS({011-AP Archive AP Tech}, [Primary Column]118, {011-AP Archive Computed Count}, {011-AP Archive Month}, 3)

TIA

Ali

Best Answer

  • AliT
    AliT ✭✭
    Answer ✓
    Options

    with a little more work - I got it!!

    =SUMIFS({011-AP Archive Computed Count}, {011-AP Archive AP Tech}, [Primary Column]118, {011-AP Archive Month}, 3)

    I swear I tried this earlier!! But I did confirm that it is adding up correctly!!

Answers

  • AliT
    AliT ✭✭
    Answer ✓
    Options

    with a little more work - I got it!!

    =SUMIFS({011-AP Archive Computed Count}, {011-AP Archive AP Tech}, [Primary Column]118, {011-AP Archive Month}, 3)

    I swear I tried this earlier!! But I did confirm that it is adding up correctly!!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!