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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!