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?

Find more posts tagged with

Formulas

Accepted answers

All comments

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")

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.