Count from another sheet



I have 2x sheets OTIF-Sept and Report I am trying to Count the total KER -111111 orders and is incremented by 1 every new order.

The count would count all orders in the Sept sheet so on a spare line if I use the following formula

=COUNT([Order Number]:[Order Number]) I get the value I require.

But if I run the below on the Reports sheet I get #UNPARSEABLE

=COUNT({OTIF-Sept Range 3},[Order Number]:[Order Number])

Can anyone explain the reason or what is wrong with the above formula.

Thanks Hargreaves



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!