Sumifs question

J Star

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!

hderryberry

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å

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