Cross Sheet reference involving dates shows INVALID DATA TYPE

Vivien Chong
Vivien Chong ✭✭✭✭✭✭

I am working on some inventory check and report.

Inventory sheet as follows:

Screenshot 2020-12-17 at 7.38.19 PM.png

Metric sheet to report on monthly incoming by items and month as follows:

Screenshot 2020-12-17 at 7.38.06 PM.png

I am trying to refer to the Inventory Sheet to sum Qty In if:

1) Level is 1 (I don't want the parent row to be calculated)

2) Equipment Description matches the primary column

3) Month matches [Nov20]2

4) Year matches [Nov20]1

But I keep getting invalid data type error.

Can anyone assist? Thanks.

Vivien Chong

Modern Work Management Consultant @ 57Network Consultancy Sdn Bhd

Connect with us: 57network.com

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!