How do I count the total entries from another smartsheet?

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!😉

Thank you very much for any help!😉

Rob

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!