I am using the PMO template.

I am trying to get the Milestone Status for a Proposal Number from the Milestone Sheet to populate the meta data sheet for that Proposal Number. Only two sheets are in play but I can't make the index match work.

Project Meta Data Sheet

Milestone Sheet

The Proposal Number Column is labeled IITRI# on both the meta data sheet and the Milestone Sheet. Please advise. I've been trying to make the formula work. I understand the first part of the formula but not how the second part works or is punctuated, because 1)Indexing proposal number acrross to sheets and matching to the status. Please advise.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!