Please help: Timesheet/hour tracker

Aaron L

I'm building a simple hour tracker and struggling with the formula. I want the formula to only produce a value when the a date (column) is = > the start of a pay period (column) and < = the end of a pay period (column).

I'm combining an already working formula that takes a row total (column name is Task Total) when a dropdown is selected (column name Category). Working formula: =SUMIF(Catagory:Catagory, "Business Development", [Task Total]:[Task Total])

I need the working formula combined with the date that is in the pay period.

Thank you for the help!

Yvonne Smythe

Hi @Aaron L - Have you tried using the Smartsheet time tracking templates?

https://www.smartsheet.com/free-timesheet-and-time-card-templates

Aaron L

Thank you so much for the suggestions!

Yvonne Smythe

You’re welcome! If nothing you can adjust to what you need by scaling down or copying a formula. All the best.