Smartsheets doing weird things
I posted the below in questions and it got marked as answered before it was actually resolved. I did not mark it as answered. The question I have is also something weird as a formula is calculating incorrectly. See screenshot of the previous question/responses
Answers
-
You're still getting a zero for the output on some rows?
-
@Paul Newcome I am and everytime a response is typed the question moves into the answered and no longer shows up in unanswered so noone new sees it.
-
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thank you @Genevieve P. The unanswered seems to be fixed today. Yesterday it kept moving all the unanswered questions. Most of the day it had 0 as unanswered questions.
-
@Genevieve P. Thanks for the link. I will respond there as well.
@Hollie Green I would suggest reaching out to Support. I agree with your reasoning that it should never output less than 1. One of the first things they will probably suggest is the "turn it off then back on again" approach which does often work for me whenever I run into something that is definitely unexpected behavior.
Remove the formula from the sheet completely.
Log out.
Clear your browser's cookies and cache.
Log back in.
Retype the formula.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!