Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Formula not working
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?
Answers
-
-
@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 =SUMIF({Europe NPS 2025 Results Range 2}, =Country@row, {Europe NPS 2025 Results Range 5})
-
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")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!