Invalid Operation Error

_Genevieve Evans

Hello,

I am trying to create metrics to review milestone phases for 2023 by week. I had my formula counting if the milestone phase is a certain value, if the date of that milestone phase was in a certain week of the year, and that the date value is not blank:

That works great. However, because I did not define the year to look at, it is counting dates that are in 2022 as you can see here:

So I went to add a new argument to only count if the year is 2023 but I get an invalid operation error when I have the function like this:

I already have an argument in that that addresses any blank cells in the range, but is the first argument in the function counting that or is it that I need to define that again in the same way as I'm defining what year to look for as well? Or is it that I have too many arguments on this range now at this point?

I hope this is making sense and I've given enough information. I really appreciate any help on this!

Paul Newcome

You need to compare the YEAR(@cell) to the YEAR of the date. Right now you are comparing (for example) 2023 to 08/18/23. You have to tell the formula to pull the year out of that.

Paul Newcome

You need to compare the YEAR(@cell) to the YEAR of the date. Right now you are comparing (for example) 2023 to 08/18/23. You have to tell the formula to pull the year out of that.

_Genevieve Evans

Ahhhhh, thank you!! I think I was staring at this formula way too long to spot it. Thanks again, @Paul Newcome, your responses to others has helped me through MANY of my Smartsheet endeavors. You always explain things in a very easy and efficient way!

Paul Newcome

Happy to help. 👍️