Sumifs question

Options
J Star
J Star
edited 12/09/19 in Formulas and Functions

Failry new to Smartsheet, I can do this so easily in Excel, but not in Smartsheet. 

I'm basically trying to add an amount requested based on whether or not the request was approved. The approval is a dropdown menu with only 3 text status - Submitted, Declined, Approved. I want to add the Request Amount column and only the values that are approved. 

I've been reading a bunch of posts here, but I cannot get this to work. This is what I have so far. 

=SUMIFS([Requested Amount]:[Requested Amount], Approval:Approval, "Approved")

 

But all I get is #UNPARSEABLE

 

hELP!

Comments

  • hderryberry
    hderryberry ✭✭✭✭
    Options

    Ok I am fairly new to Smartsheet also but I think your missing the =. 

    So it would look like this

     =SUMIFS([Requested Amount]:[Requested Amount],=, Approval:Approval, "Approved")

    I'm not 100 percent sure just trying to help. Try it and c if it works..

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Options

    Hi,

    At a quick glance, it looks correct.

    Can you maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

    I hope that helps!

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    work-bold

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!