Whys is TODAY(-90) returning values for future dates

Options

I am trying to sum the # of PTO hours an employee has used in the last 90 days for some reason my formula =SUMIFS({Missed Hours}, {TM}, $Name@row, {Type}, PTO$1, {Date}, >=TODAY(-90), {Cancel}, 0) is tallying all of the time off requested even for future dates. I would expect the value returned to be 56 however it is returning the total of 168.

Thanks In Advance for any help provided!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!