Need help creating graph - reports late
I need to create a graph, for two different people, tracking to see if reports are done on time or not. I need to use the assigned to column and then the days late column. Negative were done early, 0 were done on time (Day Of), and then positive numbers will be late.
Each graph would be just the one person, and then % completed on time/early, and then % completed late.
hopefully that provides enough information to help me create a formula for a dashboard!
Answers
-
You can filter by the current user, this will allow the user to only view what's under their name in the report.
As for the other columns, you can add / remove columns in the column tab in the ribbon.
Leroy Noriega | Smartsheet SME | Independent Smartsheet Consultant
Core App, Project Management, System Administrator and Control Center Blueprint Builder Certified🏅
E: leroy.noriega@yahoo.com | Linkedin Profile
-
On a separarte sheet…
[% Completed On Time/Early]
=COUNTIFS({Assigned To}, @cell = "John Smith", {Days Late}, @cell <= 0) / COUNTIFS({Assigned To}, @cell = "John Smith")
[% Completed Late]
=COUNTIFS({Assigned To}, @cell = "John Smith", {Days Late}, @cell > 0) / COUNTIFS({Assigned To}, @cell = "John Smith")
