Possible COLLECT or INDEX/MATCH IF between two sheets


I'm having difficulty figuring out a formula that references two different sheets. Any help would be much appreciated! Thank you!

Below are screenshots of the two different sheets along with notes/explanations.

Below is the text of the sheet names and fields for easy reference on formula ideas. That way you don't have to type out manually.

eMERGE Asset Staging Table- OFFLINE

Equipment Name

2020-2021 Status

Asset Condition Assessments- Active- OFFLINE


Condition Assessment Year

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!