Formula on Metrics Sheet all Zeros until I open the sheet

Michael Culley

This formula works perfectly fine but for some reason it defaults to 0 until I actually open the metrics page. I use this metric in a dashboard and everyday it changes back to 0 until I open the metrics page. Can someone explain why?

=COUNTIFS({supervisorDOT}, [Primary Column]@row, {completedDOT}, 0)

I even created automation daily where it locks and unlocks rows and updates a date column just in case that was needed like the TODAY() function sometimes needs.

Paul Newcome

It sounds like you may have run into a bit of a glitch. I would suggest reaching out to Support. There are some settings and whatnot that they may be able to refresh on their end that we cannot which may help.

Michael Culley

@Paul Newcome Where is the support link? Not sure where to find it.

Andrée Starå

Hi @Michael Culley

I hope you're well and safe!

Here you go!

Smartsheet Support Team.

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD