Sumif across sheets using criteria

=SUMIFS({New product Load sku}, {New Product- Prime Tab}, [Primary Column]@row, {New Load- Stage}, OR(@cell <> "Ops Team Reviewing", @cell <> "Working", @cell <> "Assign to Data Team", @cell <> "Data Team Rejected", @cell <> "Ops Team Missing Info Request Sent", @cell <> "DT Reviewed - Ready To Assign", @cell <> "With PM", @cell <> "Haresh Results Ready", @cell <> "Sent Overseas"))


trying to sum skus from this sheet using Web Prime but Data Stage should be one of the above...im missing something here


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!