Formulas working for some columns but not others after update

Good Morning,

It seems after the update I've been having issues with a formula on my project intake sheet/meta data sheet. I'm getting a #No Match error. Certain columns are connecting appropriately but others no longer are and I can't seem to identify why?

See formula below

Below is the intake sheet being referenced with the highlighted needing to captured

Any help would be greatly appreciated!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!