COUNTIFS with @cell refrence

Options

I have a column in one sheet that has data in it such as 0423-01,0423-02,.... the 04 meaning April and the 23 meaning 2023. The -01 or -02 is just the numbering system for that specific month. After April is over there will be more rows added below the 04 ones but now starting with 05 to denote we are now in May.

I am trying to create a formula that references this entire column and counts how many rows there are in the current month that we are in. For example, COUNTIFS([Item]:[Item],VALUE(LEFT(@cells,2))=MONTH(TODAY())).


I feel as though this should work but I am getting the #INVALID VALUE error. The @cells part I think is what is throwing it off but I want the criteria to be based off the range of values but only the first two characters of the cells in that range.


Any help would be greatly appreciated.


Thank you!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!