Formula not working

Lisa B 2022

Hi all,

I can't understand why this simple calculation isn't working, or if it's my brain!

I am trying to calculate in the highlighted cell, 29 * 73,000 Euro each time it returns zero.

The 29 is a formula based on other figures on the same smartsheet, whilst the 73k is a SUMIFS based on a different smartsheet.

What am i doing wrong?

Paul Newcome

What is the formula outputting the 29?

Lisa B 2022

@Paul Newcome the 29 is based on =IFERROR([% Total Promotors]@row - [% Total Detractors]@row, 1). those columns are also based on forumals pulling from the same smartsheet.

Paul Newcome

And what is the exact formula for the 73k?

Lisa B 2022

@Paul Newcome =SUMIF({Europe NPS 2025 Results Range 2}, =Country@row, {Europe NPS 2025 Results Range 5})

Paul Newcome

Try these two formulas separately (just for troubleshooting purposes) and let me know what each comes back with.

=IF(ISNUMBER([Column Name Containing 73k]@row), "Number", "Text")

=IF(ISNUMBER([Column Name Containing 29]@row), "Number", "Text")