index match formula not returning what I intended it


Dear All,

Could you please help me with this formula?

=INDEX({Project Plan - Task name}, MATCH([Start Date]@row, {Project Plan Range 1}, 0))

I wanted to show TASK NAME (from project plan) on the RACI file.

What the formula seems to be returning is the name of item in either the Parent or the Tollgate/Phase column.

Thank you in advance!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!