I am trying to count a cross reference including 2 columns using @row in my metric sheet :<

So if Category = x and Status is = "Closed" , then I will add formula in pending column etc.... I am having to build multiple sheets to gather data from multiple source reports, then combine that data on one sheet to build a report and roll up to Dashboard :< Please help, I keep getting either the wrong total or argument/invalid formula. This formula is counting all status' vs. just "closed" THANK YOU!


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!