Sheet Summary formulas

Question

Hello - I am trying to run a basic fomula on my Sheet Summary cell and am absolutly stumped!  Are there limitations on how we can use formuals on our Sheet Summary cells?

What I want to do add any rows from the weighted ECV column that have 2026 in the Year column. I think this formula should work, correct?  =SUMIFS([Weighted ECV]:[Weighted ECV], Year:Year, =2026)

It is returning #invalid operation

I am sucessfully using this similar formula on a cross reference sheet. SUMIFS({Weighted ECV}, {Year}, =2026)

Can someone help me understand the Sheet Summary formula tricks here?

For expenteded insight: Step 1 we want to build out about 20 different fields in the Sheet Summary to run formuals against individual categories. Step 2: We want to take all our project into one Sheet Summary Report to evaluate how these 20 categories are used throughout our company. Can sheet summary formulas perform basic sumif formulas?

Thank you for your help

jmyzk_cloudsmart_jp · Accepted Answer

Hi @GwenMM

I do not see a problem with your Sheet Summary formula.

https://app.smartsheet.com/b/publish?EQBCT=1bf3fdab24f94b4bb21493d4ba1bcb5f

A possible cause is an error in creating the Weighted ECV.

In the example below, '50%, a text value, not a number  %, is in the cell, causing an error in the Weighted ECV cell, and then causing #INVALID OPERATION in the Sheet Summary field.

Shaz · Accepted Answer

@GwenMM check both Weighted ECV and Year column data. If any one data is already an error or one data in year is non number will cause this. Keep it a practice for any #invalid error to check the data type and quality.

What you are trying to achieve is best usecase for sheet summary. Get the 20 parameters calculated on a sheet summary and use it is template.