Hello,
I have spent HOURS on this and help.
This for "Invoice/Sheet Received" Parent column with drop downs. I am combing the Parent code AND child codes so can click+drag it down my sheet. I want to keep this. So the first part of this is for the Parent, the 2nd is in relation to the child. I keep getting Errors on my Parent side.
[Invoice/Sheet Received] - Text/Number column
[Status] - Drop Down
[#Left to use] - Numerical
EDIT: I am getting the #Invalid Date Type error. But what I am looking for is text/ in the Parent...
Here is my formula:
=IFParent@row <> "", IFCOUNTIFSCHILDREN), "Received"), "Received", IFCOUNTIFSCHILDREN), "No"), "No", IFCOUNTIFSCHILDREN), "Partial"), "Pending", IFCOUNTIFSCHILDREN), ""), "TBD")))), IFStatus@row = "Product Removed", "N/A", IFANDP2@row = "", [Product Item@row <> ""), IF# Left to use@row > 0, "Partial", IF# Used on sheets@row <> "", "Received", "No")))))
I've tried it with both COUNTIFS and COUNTIF and with/without IFCount__
Thank you SO MUCH for any and all help you can provide!!