Why am I receiving #INVALID OPERATION error in some of my sheets

Omid

I have multiple sheets with the same columns (Health, Task Name, Start, Finish). Note that the Health column is a symbol (red, yellow, green, blue). In my summary sheet, I am using the following Index Match formula to search for Task A in Task Name column and spit out Health.

=INDEX(Health:Health, MATCH("Task A", [Task Name]:[Task Name], 0))

However, on some of my sheets, I am getting #INVALID OPERATION error and I can't seem to figure out why.

Paul McGuinness

Hi @Omid

Are all the columns formatted correctly as symbol and the same type?

Where you are receiving invalid operation errors is the criteria Task A present in those sheets? as the error could be that it cant find Task A so cant deliver a result.

Thanks

Paul

Omid

https://community.smartsheet.com/discussion/comment/361105#Comment_361105

Hi @Paul McGuinness , The Health column is formatted as symbol. (see attached) and Task A is within the sheet under Task Name column.

Capture.PNG

Capture.PNG

Omid

https://community.smartsheet.com/discussion/comment/361105#Comment_361105

Hi @Paul McGuinness , The Health column is formatted as symbol. (see attached) and Task A is present within the sheet under Task Name column. The field in summary sheet is also formatted as Symbol.