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
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!