Same Formulas & Invalid Data Type

Ryan Nix

Hello,

I hit a bit of a snag and was wondering if anyone could help me out. I have this metrics table that I am using to create a roll up based on the root causes and the month it was created (image below)

Each of these cells has a roll up formula that's supposed to remain consistent:

=COUNTIFS($[Cause of aged ticket]:$[Cause of aged ticket], PARENT(), $[Ticket submitted date]:$[Ticket submitted date], MONTH(@cell) = $Month@row) + COUNTIFS({Root cause age}, PARENT(), {Ticket Submitted Date}, MONTH(@cell) = $Month@row)

For some reason, the "Mgt of vendor" column has an Invalid Data Type result. I can change it to something like "Process" and it'll match the process column but if I change it to "Management of vendor", or even change the formula to say "Mgt of vendor" instead of Parent(), it'll return the same error. Anyone have any thoughts on what I am doing wrong?

Mark Cronk

Good morning @Ryan Nix ,

I suspect the error is in your source data. It only takes 1 cell. Scan your Mgt of Vendor data looking for an entry that's not like the others.

Mark

Mark Cronk

Good morning @Ryan Nix ,

I suspect the error is in your source data. It only takes 1 cell. Scan your Mgt of Vendor data looking for an entry that's not like the others.

Mark

Ryan Nix

Ahh, thanks for the nudge! It turned out that one of the items with the "mgt of vendor" was missing a date.