Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Roll-up metrics for an Insight - Help needed

I am creating a dashboard for all my development work. 


My tasks sheet is pretty standard with Assigned to, Status, Phase, Effort


The metrics I am looking to display are: 

  • - Total number of days (Effort) per developer
  • - Total number of tasks in a given Status (but exclude some rows in given phase)
  • - Total number of tasks in a given Phase (but exclude some)


I believe I need to create reports or something to get these values but I am struggling to find any relevant tutorials. 


Thank you very much in advance for any pointers.


This discussion has been closed.