How to do a date range in SMartsheets

Ron0935

This formula works in excel but won't work in smartsheets How would I write it

=SUMIFS({pMPS Active Cancelations Range 3}, {pMPS Active {pMPS Active Cancelations Range 1}Range 1,"Page",{pMPS Active Cancellation Range 4},">="&Date(11/1/21),{pMPS Active Cancellation Range 4},"<="&Date(10/31/22}))

Paul Newcome

Try something like this:

=SUMIFS({pMPS Active Cancelations Range 3}, {pMPS Active Cancelations Range 1},@cell="Page",{pMPS Active Cancellation Range 4},@cell>=DATE(2021, 11, 01),{pMPS Active Cancellation Range 4},@cell<=DATE(2022, 10, 31))