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

  • Hi @Teresa Santosus

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!