resource time calculations

edited 12/09/19 in Smartsheet Basics


Is there an easy way to sum the time tasked to specific resources. I want to populate an estimate based on my schedule I created but I don't see a way to easily determine how much time each resource has been allocated. I can export to excel and manipulate columns, filters etc. but it seems that there should be some way to simply see how much time as been assigned to someone without having to go though so many steps and subject to error.


  • Alejandra
    Alejandra Employee


    You could consider creating a SUMIFS formula like the one below, to sum the duration column if a specific person is assigned:

    =SUMIFS(Duration:Duration, [Assigned To]:[Assigned To], "Alejandra")

    However, if your sheet has hierarchy, you'll want to modify the formula to exclude parent rows. For example, you could create a new (Checkbox) column and insert formula like the one below to identify parent rows:

    =IF(COUNT(CHILDREN([Primary Column]@row)) > 0, 1)

    The final formula you would use to sum the duration based on the Assigned To resource would look like this:

    =SUMIFS(Duration:Duration, [Assigned To]:[Assigned To], "Alejandra", [Helper Col]:[Helper Col], <>1)


    Also, if you have any feedback you would like to relay to our Product team, please feel free to submit a Product Enhancement Request.