Cross-sheet formula help required


I am using the formula from Smartsheet template Metadata sheet to capture data from intake sheet. However, one of the column doesn't seem to work, anyone has any idea what went wrong?

This is the Metadata sheet, the data in red is incorrect. I am using this formula across from "Created by" to "Description":

=INDEX({Portfolio Intake Reference}, MATCH($[Project ID]@row, {Portfolio Intake Project ID}, 0), MATCH([Created by]$1, {Portfolio Intake Header Row}, 0))

Instead of showing "Harley Sterling", it is displaying the "Financial Systems Upgrade".

This is the Intake Sheet:

Anyone has any idea?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!