SOLVED Invalid Value with COUNTIFS Formula


SOLVED: there were a few invalid values in there causing the counts to not work properly. Lesson learned


I have a COUNTIFS formula that works just fine with my Contact Column data but is not working with a text column; it gives the Invalid Value error. This is the COUNTIFS formula

=COUNTIFS([Account Director]:[Account Director], [Account Director]@row, [Contract End Date]:[Contract End Date], "", [YTD Goal Pacing]:[YTD Goal Pacing], >[Day of Year]@row).

The Contact Data is actually an index(collect formula and the Text Data is also a formula. It's a simple IF formula but it seems to be making my formula not work. If I use pasted data, it works fine but if it's a formula, it's not counting as expected. Does anyone have a solution?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!