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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!