Work due in the next 7 days

Where am I going wrong with this formula? I want to see tasks that have a {Need by Date} of TODAY through the next 7 Days and also filter out any Assignee's {Task Range 1} that say "Schedule Milestone"? Thanks for everyones support on this one :) Both of the datasets would both be pulling from another sheet.

=COUNTIFS({Tasks Range 1}, <>"Schedule Milestone", {Need by}, >=TODAY(7))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!