Formula to show how many items have been closed in past two weeks by Team assigned

Amanda Kight

Question - I'm new to Smartsheets and have been trying to figure out how to show how many items have been completed in the past two weeks based off of the closed date within my data set. I'd also like to see it by team if possible. I've tried the following formula however it always gives me 0. Any ideas?

=COUNTIFS({Department}, "Shipability", {Completed}, =TODAY(-14))

• I change each department to it's assigned name ( total of 8 teams)

Paul McGuinness

HI @Amanda Kight

Looking at your formula I would try this as your formula was only looking for dates 14 days ago, whereas including the ' > ' in the formula means its looking at any date in the last 14 days.

=COUNTIFS({Department}, "Shipability", {Completed},>= TODAY(-14))

Hope that helps

Thanks

Paul

bisaacs

Hey @Amanda Kight,

Does your date criteria work if you change it to anything else, such as just having it be TODAY()?

The formula should work, especially if you're not getting any sort of error. Is the Completed column a date column?

Amanda Kight

My completed column is a date column. It's populated when the status is changed to complete .
I tried to leave it blank as well as add in the -14 for two weeks( or i thought) but it's still not populating correctly. I went back to the sheet I'm referencing and there is inventory that's been closed as of yesterday but the team is still showing as 0 with my formula.

Paul McGuinness

HI @Amanda Kight

Looking at your formula I would try this as your formula was only looking for dates 14 days ago, whereas including the ' > ' in the formula means its looking at any date in the last 14 days.

=COUNTIFS({Department}, "Shipability", {Completed},>= TODAY(-14))

Hope that helps

Thanks

Paul

Amanda Kight

Thank you So Much Paul, that worked! I knew i was missing something, didn't even dawn on me that it was a > .