Help with making this work.

David2425

At the moment I am getting an error when trying to use this function. What can I do for it?

=SUMIFS([Hours Left]@row, [Assigned To]@row, "Person's Name", [Due Date]@row, ">="&DATE(2023,8,1), [Due Date]@row, "<="&DATE(2023,8,31)

Paul Newcome

Looks like maybe you are using Excel syntax instead of Smartsheet syntax. Try this:

=SUMIFS([Hours Left]@row, [Assigned To]@row, "Person's Name", [Due Date]@row, >=DATE(2023,8,1), [Due Date]@row, <=DATE(2023,8,31)