How do I count the entries from a column from another smartsheet?

I need to count total entries from another column from another smartsheet minus out scope criteria.

i.e. 1st Smartsheet, column 1 Title “Total Sites in Scope”

2nd Smartsheet, Column 1 Title “Site IDs” that has entries. Column 2 Title “Order Status” dropdown option “out of scope”

Solution: 1st Smartsheet, column 1, cell 1 needs to show the total of entries from 2nd Smartsheet column 1 minus the column 2 “Order Status” “Out of Scope”

This solution must include any new row with Site ID on 2nd Smartsheet that I create

Any help, I will appreciate very much!

Rob😉

Find more posts tagged with

Formulas

Support

functionality

IT & Operations

Project Management

Accepted answers

Amit Wadhwani

Hi @Rob_NYC

You can try the below formula for counting the entries. Apply this formula in sheet 1, and provide the reference from sheet 2

=COUNT({id}) - COUNTIF({order status}, "out of scope")

Id is referring to sheet 2 Site IDs and order status is referring to the Order Status column. I hope this helps.

Thank You

Regards

Amit Wadhwani, Smartsheet CoE, Ignatiuz Software, Exton, PA

https://www.linkedin.com/in/amitinddr/

All comments

Dale Murphy

@Rob_NYC Are you familiar with the function COUNTIFS()? Have you used it across more than one sheet? I think it solves your issue:

https://help.smartsheet.com/function/countifs?frame=0&nav=1

Amit Wadhwani

Hi @Rob_NYC

You can try the below formula for counting the entries. Apply this formula in sheet 1, and provide the reference from sheet 2

=COUNT({id}) - COUNTIF({order status}, "out of scope")

Id is referring to sheet 2 Site IDs and order status is referring to the Order Status column. I hope this helps.

Thank You

Regards

Amit Wadhwani, Smartsheet CoE, Ignatiuz Software, Exton, PA

https://www.linkedin.com/in/amitinddr/

Rob_NYC

Amit

Thank you very much for your help!

Rob

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.