Time tracking / Formulas.


I'm trying to setup the following:

• Time tracking spreadsheet with the following columns: Date, Client, Project, Time (increments of .25 hrs)

• either in the same sheet or different: Ability to either loop through each row and spit out all projects and time spent during the month. (We Bill each client at the end of each month)

First attempt, I created a time tracking sheet with those columns mentioned above, and went to run a report to do this, but I don't think it's possible.

Second attempt I was going to list the active projects in each month and run a formula for each project to total the hours. This works, but it's not ideal. Very manual. The code I used was:

=SUMIF(Project8:Project32, "December Retainer", Time8:Time32)

Works well, but I was looking into the HAS function to say if this row has the month January in the Date column, then do the SUMIF formula, but I think that not correct thinking. 

Point being, it would be ideal to say loop through all rows with the month of January in 2020, spit out all unique projects and total the time spent per project. Is that even possible? Not sure if I'm over complicating things. 


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!