Summary Field, Date Within Range using SUMIFS

Hi, I am trying to use the following SUMIFS formula but I receive a "#INVALID OPERATION" error when trying to create a Sheet Summary Field using the formula.

=SUMIFS(Hours:Hours, Status:Status, "Confirmed", FinishDate:FinishDate, >=12/10/2021)

However, if I remove the ">=" and just use the date 12/10/2021 I do not get the invalid operation error message. That does not work because I am trying to figure out how to sum the Hours field if the project is Confirmed and the date falls after a certain date, not just on a specific date.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!