SumIf across SmartSheets

Is there a way to create a sumif formula that references cells on a different sheet.

If I'm entering the formula on worksheet2 but suming values from worksheet1 column2 if worksheet1 column1 values match worksheet2 comlumn5 values.

Example: =Sumif(sheet1!column1:column1,column5,sheet1!column2:column2)

I can't figure out, or find, the correct syntax for this.

Thanks

Find more posts tagged with

Formulas

Comments

Brett Evans

you can not do this yet. apparently some cross sheet functionality is in the works.

Kennedy Stomps

Hi Robert-- Brett is correct, this is something our Development team is working on for a future release. We'll keep you updated here in the Community when we have more information to share!