Sum in a report shows zero for cells with value

edited 11/21/23 in Formulas and Functions

Hello, I am building a report and inserting a basic sum recap, but the value shows as zero even if the cells targeted have data in it. Is it possible the problem comes from the fact that is is not a pure value but actually the result of a multiple IF formula ?

Here is a screenshot of the source in the sheet :

When I select the column, no sum or average are shown at the bottom, just a count :

And the intended report looks like this with zero as a SUM ("Somme" in French) :

I'm in a French display, sorry if it makes things a bit trickier.

Can you help me find a way to sum or average my data in the report recap option ? Thanks,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!