# Invalid Operation

Marilen.Navarro103391
Marilen.Navarro103391 โœญโœญโœญโœญโœญ

Hi,

I've been getting Invalid Operation. I've been using this formula for other associates. I have the dates columns in column type "Dates" and Status in Dropdown.

Can you assist the reason why I'm getting this error. Thanks.


image.png


image.png


image.png


Best Answers

  • Genevieve P.
    Genevieve P. Employee
    Answer โœ“

    Hi @Marilen.Navarro103391

    I've tested your current formula and the structure is correct, so you have all the right operators in the ROUNDUP(AVG(COLLECT formula.

    However, I see that you have a formula calculating the Duration (Day) column. Is it possible that there's an error anywhere in this column? Formula errors are a bit like dominoes... if you have an error in one cell in a column that your top-level formula is referencing, it will display this error, even if your current formula is correct.

    Try adjusting your Duration (Day) column formula to have an IFERROR wrapped around it, to see if this then fixes your other formula.

    Let me know if this helped!

    Cheers,

    Genevieve

    Need more information? ๐Ÿ‘€ | Help and Learning Center

    ใ“ใ‚“ใซใกใฏ (Konnichiwa), Hallo, Hola, Bonjour, Olรก, Ciao!๐Ÿ‘‹ | Global Discussions

  • Marilen.Navarro103391
    Marilen.Navarro103391 โœญโœญโœญโœญโœญ
    Answer โœ“

    @Genevieve P.

    Thank you. There was an error in one of the cell. You're right! As always, thanks

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!