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

Options
✭✭

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😉

Thank you very much for any help!😉

Rob

• ✭✭✭✭✭✭
Options

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 WadhwaniSmartsheet CoE, Ignatiuz Software, Exton, PA

Best Regards

Smartsheet CoE, Ignatiuz Software, Exton, PA

• ✭✭✭✭✭✭
Options

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

dm

• ✭✭✭✭✭✭
Options

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 WadhwaniSmartsheet CoE, Ignatiuz Software, Exton, PA

Best Regards

Smartsheet CoE, Ignatiuz Software, Exton, PA

• ✭✭
Options

Amit

Thank you very much for your help!

Rob

Thank you very much for any help!😉

Rob

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!