using the SUMIF formula to pull data from another file and display in a separate smartsheet

Deborah Kardash

In Excel I can use the SUMIF formula to calculate data from one spreadsheet and show the sum in another Excel file. Excel Formula =SUMIF('2020 Data'!B:B,A5,' 2020 Data'!F:F) - Column B has Supplier List and Column F has all the amounts of spend by PO number in Column A

When I try with Smartsheet I keep getting #UNPARSEABLE or #INCORRECTARGUMENT

Name of File were data is located is Tracking

Supplier is one column

Amount is another column that I need to SUMIF based on Supplier

Storing in my Dashboard working file

Supplier Column Total Amount Column

Any help would be appreciated.

Thanks

Andrée Starå

Hi Deborah,

In Smartsheet you’d use cross-sheet formulas instead.

More info:

https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Deborah Kardash

Hi Andrée,

Thanks for the information. I am not able to find a good example template to follow to see if this will work.

Any information would be appreciated.

Deb

Deborah Kardash

Example Summary Report.xlsx

Example SUM Data.xlsx

I am including two files to show what I was trying to do and I am still not able to get the formula to work. Any help would be appreciated. Thanks

Andrée Starå

@Deborah Kardash, I missed getting back to you on this. Do you still need help or have you solved it?

Deborah Kardash

Hi Andree,

No, but I do have a new discussion topic and maybe you will have some ideas for me there.

Thanks

Deb

Andrée Starå

Glad you got it working! 

Best, 

Andrée