Same Formulas & Invalid Data Type

Ryan Nix
Ryan Nix
edited 11/23/20 in Formulas and Functions


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?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!