SUMIF formula within last 7 days
angelapaj
✭✭✭✭
Hi,
I need help with one of my formulas. I have an hours repository sheet where all employees log their hours. They include their names, week of (first Monday of each week) + number of hours spent on each project.
I am now creating a separate sheet where I need to pull the number of hours logged by each employee in the last 7 days. I keep getting the INVALID OPERATION error with my formula.
=SUMIFS({No of hours spent}, {Name}, =[Full Name]@row, AND({Week of} > TODAY(-8), {Week of} < TODAY(+1)))
Can you please help?
Answers
-
Hi @angelapaj -
This should solve it:
=SUMIFS({No of hours spent},{Name}, [Full Name]@row, {Week of}, AND(@cell > TODAY(-8), @cell <= TODAY()))
Linda
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!