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

Rob_NYC

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😉

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/

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

dm

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