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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives