Deleted Row affecting Metric Widget Count
I was doing a test row to see if I had my Metric Widget Count correct. Once I confirmed it worked, I deleted the row.
Now the metric count is still indicating 1 (which was the test row). Is there any way to remove this?
The sheet is basically a meeting request form, the count will show until "meeting scheduled" is checked. Unfortunately, I cannot get the row back to check the box and I do not like seeing 1 in my count as it is a false count. I re-did the widget and it still show the same.
Answers
-
Since Metric Widgets cannot create calculations, they only display information that is already present in the sheet, it sound like you may have built a formula somewhere that looks at your sheet to count rows, is that correct?
If so, can you post the formula in here? It would also be helpful to see a screen capture of the grid that the Metric Widget is pointing at, but please block out sensitive data.
Cheers,
Genevieve
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!