Cross Sheet reference involving dates shows INVALID DATA TYPE

Options

I am working on some inventory check and report.

Inventory sheet as follows:

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

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.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!