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.
Date based formula problem
Hi there
Can anyone help me with the following formula please? I've published a form which we use for collecting 'hours spent' on each project per day of week (based on a 'week commencing' field).
I alreday have a report which then pulls out the time spent based on 'individual' and 'project' but I can't get the 'by week commencing' to return anything (comes back as a 0 in the totals column)
I'm guessing that I don't have something right with the DATE part of the formula. I have tried the SUMIF both ways, with the Total Hours at the start and at the end of the formula.
=SUMIF([Week Commencing]:[Week Commencing], "=DATE(2016,1,3)", [Total Hours]:[Total Hours])
Sample data below:
Any help would be greatly appreciated.
Many thanks
Phil
Comments
-
Phil,
I can't see the sample data. However, try this:
=SUMIF([Week Commencing]:[Week Commencing], DATE(2016,1,3), [Total Hours]:[Total Hours])
I think the criteria is confused.
Hope this helps.
Craig
-
Thanks for this Craig, works a treat!
I can see where I was going wrong.
Big thumbs up to the community, works well.
