How do I count the total entries from another smartsheet?

Rob_NYC

I want to count the total entries from one column from another smarsheet minus out of scope entry from another column from that sheet?

i.e: 1st Smartsheet column 1 says "Total Sites in Scope". 2nd Smartsheet column 1 says "Site IDs" and 2nd column says "Order Status" with a dropdown that says "out of scope"

1st Smartsheet column 1 cell 1 should give me the total count of "Site IDs" entries minus the "Out of Scope". This formula needs to calculate any new row that I add with the "Site ID" to the 2nd Smartsheet.

Thank you very much for any help!😉

Paul Newcome

You would use something like this:

=COUNTIFS({Source Sheet Order Status Column}, @cell <> "Out of Scope")

Paul Newcome

If you will not always have a status then you would need to use this:

=COUNTIFS({Source Sheet Site ID}, @cell <> "", {Source Sheet Order Status Column}, @cell <> "Out of Scope")

Paul Newcome

Happy to help. 👍️

Paul Newcome

You would use something like this:

=COUNTIFS({Source Sheet Order Status Column}, @cell <> "Out of Scope")

Rob_NYC

I was thinking to user the SITE ID Column to count and use the Order Status Column to subtract the count from SITE ID column. There reason is, SITE ID will always be an entry but might not have always an entry.

Your formula works fine, but I'm afraid if I create a new row with the site id number and I might not have status immediately to enter in the Order Status.

Thank you very much!

Rob

Paul Newcome

If you will not always have a status then you would need to use this:

=COUNTIFS({Source Sheet Site ID}, @cell <> "", {Source Sheet Order Status Column}, @cell <> "Out of Scope")

Rob_NYC

Paul

Thank you very much for your help!

Rob

Paul Newcome

Happy to help. 👍️