#Invalid Operations

I have what I thought is a simple formula, but I get the #Invalid Operations


Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @Shannon Lacerda

    You're missing the second cross-sheet range which tells the formula what column to look into to find the month.

    Ex:

    =COUNTIFS({Elevated Bid Proposal}, "Bid", {Bid Due Date Column}, IFERROR(MONTH(@cell), 0) = [Month Number]@row)


    Note that I also wrapped an IFERROR around the MONTH function in case there are blank cells in your Due Date column. Does this make sense?

    Cheers!

    Genevieve

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!