INDEX/MATCH works in one sheet, same formula gives #INVALID OPERATION in another

Hi all

I have a Project Info section of my schedule sheet that I pull into columns so that the info can be used in automated emails about tasks. The sheet that's giving me problems is a copy of another sheet, where the formula works.

=INDEX([Task Description]:[Task Description], MATCH("Portfolio", Task:Task, 0))

It works just fine in the original sheet and other sheets that are a copy of that one, but for some reason in this one it's throwing an #INVALID OPERATION error. The Task Description in the working sheets is linked to the Planning sheet as well, and it still throws an error for the Component row, which is not linked to anything. All columns are formatted as text/number.

Thanks in advance for any help!

Answers

  • Michelle Choate 2
    Michelle Choate 2 ✭✭✭✭✭✭

    The invalid operation error is letting you know that while the formula syntax itself isn't necessarily wrong, you may still be trying to use incorrect data types for a particular function such as trying to use dates in a SUM function or blanks in a MONTH or YEAR function.

    I just tried your formula in my sheet as well and it worked perfectly. So I would check again just to make sure what your column types are. Maybe even switch them to something different, then save, then switch them back, then save and see what happens.

    Michelle Choate

    michelle.choate@outlook.com

    Always happy to walk through any project you need help with!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!