Looking for Formula where count of distinct PO #s in a given PO month

I'm looking for a formula, where need count of unique PO # falls in a month. In this formula, I used specefic PO # i.,e "123" but I need count of all PO # falls in a given month (See the screen shot attached)

=COUNTIFS([PO Date]:[PO Date], IFERROR(MONTH(@cell), 0) = MONTH(Date12), [PO Date]:[PO Date], IFERROR(YEAR(@cell), 0) = YEAR(Date12), [PO #]:[PO #], "123")

Kindly help me out on this.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!