Invalid Operation Error

Hello,

I'm encountering an #invalid operation error and can't seem to identify the cause...

Any input would be greatly appreciated

Thanks!

Best Answer

  • Shimanta Roy
    Shimanta Roy ✭✭✭✭
    Answer ✓

    Hi Bryan, firstly remove the "=" sign before the second and third IF function and see if you are still getting the error.

    Senior Business Intelligence Analyst
    Augmedix Bangladesh
    (A Commure Company)
    shimanta@augmedix.com

Answers

  • Shimanta Roy
    Shimanta Roy ✭✭✭✭
    Answer ✓

    Hi Bryan, firstly remove the "=" sign before the second and third IF function and see if you are still getting the error.

    Senior Business Intelligence Analyst
    Augmedix Bangladesh
    (A Commure Company)
    shimanta@augmedix.com

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!