Formula on Metrics Sheet all Zeros until I open the sheet

Options

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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!