Countif

I don't know if I should use the Countif or Countifs but either way, my formula isn't working for me. I'm trying to count the Progress Status of each Team member's project.

So my Source file is "Masterfile" and my column is "Progress" and each status is "Not Started" or "In Progess" or "Completed"

When I tried to do the formula:

=COUNTIFS({Masterfile HR Intake Project Sheet Range 5}, Variables@row, "Not Started")

I get error INCORRECT ARGUMENT

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Are you able to provide some screenshots for context?

Roxanne Basgen

my graph has the correct #s but as you can see, my widgets are displaying incorrect #s.

My metric sheet is:

Paul Newcome

It looks like your metrics sheet has the same numbers as your chart. How exactly did you create the metrics widgets? It looks like there is data below some of the initial numbers in some of the metrics widgets. Are you able to scroll down on the metrics widgets?

Roxanne Basgen

I didn't use the widget behavior, I believe this was a template and I did cut and paste to the existing widget on teh template:

Does the Smartsheet Technical team help with questions like this?

Paul Newcome

Try adjusting what data is shown in the metrics widgets. It doesn't have anything to do with the widget behavior. Lets look for an example there in the "Completed" widget. See how it looks like there may be text underneath of the number 2? What's down there?

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.