Formula on Metrics Sheet all Zeros until I open the sheet
This formula works perfectly fine but for some reason it defaults to 0 until I actually open the metrics page. I use this metric in a dashboard and everyday it changes back to 0 until I open the metrics page. Can someone explain why?
=COUNTIFS({supervisorDOT}, [Primary Column]@row, {completedDOT}, 0)
I even created automation daily where it locks and unlocks rows and updates a date column just in case that was needed like the TODAY() function sometimes needs.
Answers
-
It sounds like you may have run into a bit of a glitch. I would suggest reaching out to Support. There are some settings and whatnot that they may be able to refresh on their end that we cannot which may help.
-
@Paul Newcome Where is the support link? Not sure where to find it.
-
I hope you're well and safe!
Here you go!
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 360 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!