Average of days for a report/metric
Options
I am trying to run a report using the following formula that references another sheet
CRU Range 1  is the name of the investigator, CRU Range 3 is the type of case and i need an average of the days closed (which is CRU Range 4).
So the result should be Vanessa's average days to close a CRU Phase 1 case is 25 days.
The formula i have right now(below) is giving me an unparseable error.
=AVERAGEIF({CRU Range 1} "Vanessa Diaz", {CRU Range 3}, "CRUPhase 1", {CRU Range 4}, ="")
Answers

You are missing a comma after {CRU Range 1}. Try =AVERAGEIF({CRU Range 1}, "Vanessa Diaz", {CRU Range 3}, "CRUPhase 1", {CRU Range 4}, ="")

Thank you for answering Adam! I tried that but now i'm getting incorrect argument set?
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!