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.
Sum Values Between Two Dates
I'm looking for some help with a formula. I've created a complicated system of sheets where a contractor enters her/his hours into a form each day they work and I link the data into a contractor's individual sheets which then feed into a series of formulas which feed into reports which feed into sights.
What I need to do is to create a formula within each individual sheet that calculates the hour's that that person has worked each week.
So I created a Week Start Date column, a Week End Date column, and a Total Hours worked per week column. This is the formula I created that keeps coming up #unparseable:
=SUMIFS([NG Hours Worked]:[NG Hours Worked],[NG Date]:[NG Date],[NG Date]>=[AJ Week Start]3,[NG Date]:[NG Date],[NG Date]<=[AJ Week End]3)
NG Hours Worked is a column that has a formula that brings in only the hours that this person worked. This ultimately comes from the form that this person entered her/his hours.
NG Date is a column is a column that has a formula that brings in the date of the hours that this person worked. Same source as above.
Everything I look up tells me that my formula is correct, however I cannot get it to work. Any help would be greatly appreciated!