Need assistance with a Metric
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!
Answers
-
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!
Best,
Zach Hall
Training Delivery Manager / Charter Communications
-
That was what I was missing, thank you!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives