Index Match Formula help. Index Match of Health status of an activity into Sheet Summary

Omid
Omid ✭✭
edited 02/24/23 in Formulas and Functions

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 symbol.

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

However, on most (not all) of my sheets, I am getting #INVALID OPERATION error and I can't seem to figure out why.

Note: Both Field 38 and Health column is formatted as symbol. (see attached).


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!