Count from another sheet

Options

Hi,

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

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!