Hi All,

I've been trying to put a metric in place for my dashboard which splits up how many tasks are Open or Closed within certain division. I am referencing the main works sheet and columns there for the range. I was also trying to reference my metric sheet for cell values for Open/Closed and specific division but gave up as nothing works. I tried leaving gaps between commas, I tried no brackets...

Latest formula I have tried which gives #UNPARSEABLE


Any tips of what I am doing wrong be great!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!