Using References to pull info across sheets

I'm new to Smartsheet, so I expect this to be an easy question. I'm using References to pull info across sheets and I need a cell count from the Category Column with an input of "Category 1" only if the Status Column in that row has an input of "Not Started". Here's a copy of my unsuccessful attempt.

=COUNTIFS({Project Status}, "Not Started", {Project Category}, "Category 1")

I get #Incorrect Argument Set error

Appreciate any help on this. Thanks

Find more posts tagged with

Accepted answers

TedJ

HUZZA,

OK, if you are having this issue, I will share one solution. On the sheet that I am pulling info from I picked an out of the way cell and wrote this formula,

=COUNTIFS([Project Status]:[Project Status], "Not Started", [Project Category]:[Project Category], "Category 1")

Then on the destination sheet I linked the cell that I needed this information, to the cell on the other sheet that I used to create that formula. It worked, although to get updated information on the destination sheet I have to "Refresh" it and the cells update with the info I need. Thanks

All comments

heyjay

I used your formula and it seems to be working fine for me. That error message usually means an extra comma or missing comma for the function you are using.

#Incorrect Agurment Set

TedJ

Are you using Reference to pull info across sheets as indicated by the {} brackets in my formula. Asking because I've been at this for two days with no success.

TedJ

HUZZA,

OK, if you are having this issue, I will share one solution. On the sheet that I am pulling info from I picked an out of the way cell and wrote this formula,

=COUNTIFS([Project Status]:[Project Status], "Not Started", [Project Category]:[Project Category], "Category 1")

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.