Need assistance with a Metric

TinaM

Hi,

I am trying to get the % of task within a milestone that are complete. I trying to use: "=SUMIFS({Status}, "Complete", {Milestone}, "30 Days post Merger Date Milestone") / [Total of tasks]@row" but I keep getting an error. I think it has to do with the "/[Totalof tasks]@" row but I can't figure it out.

Thanks!

Zachary Hall

Hi @TinaM,

It looks like the syntax of your SUMIFS() isn't quite right. It appears you are missing the range you want the SUMIFS() to add up. I believe the {Status} range you have first is what you want to check to see if it is "Complete". Here is the proper syntax, but you will need to substitute the {Value to Add} range in the formula with the proper range from your sheet.

• =SUMIFS({Value to Add}, {Status}, "Complete", {Milestone}, "30 Days post Merger Date Milestone") / [Total of tasks]@row

I hope this helps!

TinaM

That was what I was missing, thank you!