Why is this function not working?
=SUMIFS([Hours Left]@row, [Assigned To]@row, "Person's Name", [Due Date]@row, >=DATE(2023, 8, 1), [Due Date]@row, <=DATE(2023, 8, 29))
I have values in the "SUMIFS" column, but it does not work. What is wrong. It is giving me the output of all my values being zero.
Answers
-
Hi @David2425,
What is it that you would like for the formula to do?
Currently it looks like it is adding the amount of hours left if the "Person's Name" matches the criteria.
What are you expecting as an output?
Sincerely,
Jacob Stey
-
@SteyJ ,
I would like to display the number of hours of work left per task if the end date falls between those dates listed. I want it to be able to display this for each task.
-
If you want to SUM the amount of hours per individual you can use this formula:
=SUMIFS([Hours Left]:[Hours Left], [Assigned To]:[Assigned To], "NAME HERE", [Due Date]:[Due Date], >=DATE(2023, 8, 1), [Due Date]:[Due Date], <=DATE(2023, 8, 29))
If you want to SUM the hours left per task, that formula will be a little different depending on the column name for tasks.
=SUMIFS([Hours Left]:[Hours Left], [Task Column]:[Task Column], "Task Name", [Due Date]:[Due Date], >=DATE(2023, 8, 1), [Due Date]:[Due Date], <=DATE(2023, 8, 29))
Sincerely,
Jacob Stey
-
Hi,
I hope you're well and safe!
Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!