Why is this function not working?

David2425

=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.

SteyJ

https://community.smartsheet.com/discussion/108920/why-is-this-function-not-working

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?

David2425

@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.

SteyJ

https://community.smartsheet.com/discussion/comment/390514#Comment_390514

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))

Andrée Starå

https://community.smartsheet.com/discussion/108920/why-is-this-function-not-working

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!