Trying to only pull the month from a cell if the a certain drop box is picked

Options

I am trying to count the amount of projects in a month with the date entered but only pull it out if a the drop down box says archived, I believe the month count is correct as that part alone works but when trying to add the code for the dropdown box it does not work, any help would be apricated, code below;

=COUNTIFS({Project Quality Engineer Project Updates Range 8}, <=DATE(2022, 3, 31)) - COUNTIF({Project Quality Engineer Project Updates Range 8}, <=DATE(2022, 3, 1)) COUNTIFS({Project Quality Engineer Project Updates Range 5}, "archived")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!