Formula on Metrics Sheet all Zeros until I open the sheet

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.

Find more posts tagged with

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.