Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Does anyone know what NaN% means?
Hi all,
I'm getting NaN% appear on my sheets where that cell is linked to another sheet. The source cell appears OK, and I've tried remaking the link, but no affect.
Is this the 2000 links I'm running up against?
There are a lot on my sheet....
Regards - Roland
Comments
-
I'm getting the same thing. I have contacted Smartsheets.
-
Could one of you post a screen shot?
There is nothing about NaN% in Help or the API doc.
Craig
-
David,
Roland mentioned linked cells, I don't see any in your sheet.
Are yours in cellls with formulas?
Craig
-
Just got this from support. The problem for me is in the conditional formatting that I discovered, not in linked cells or formulas.
Hi Dave,
Thanks for following up with the additional information and the screenshot. As you've noted, this issue is being caused by a conditional formatting rule. We've opened a bug and are conducting research to determine a fix.
As we work to resolve the issue, there's a workaround you may be able to use to get the values to display correctly. To do this, remove the font size change from the conditional formatting rule.
I'll circle back with you once I have more information or see that the issue has been fixed.
Kind regards,
Leo
Smartsheet Support
-
Morning,
it looks like the bug is cleared. After going in to some of the affected sheets this morning, they showed the NaN% value for a few seconds, then it changed to the correct value.
Toi confirm, they were conditionally formatted cells with currency values in them, and a font size (amongst other things) conditionally applied.
Thanks - Roland
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives