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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!