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
Check out the Formula Handbook template!