Formula Help! INDEX(COLLECT)


I have two sheets and two columns i am trying to compare:

1) Finished Lot Inventory Summary

Column Name: Development

Column Name: Lot Number

Column Name: Finished Lot Inventory Count

2) Starts Schedule

Column Name: Subdivision

Column Name: Lot

Column Name: Notify

On the 'Starts Schedule' sheet, I am trying to populate the column 'Notify' with the value from the column 'Finished Lot Inventory Count' if the Subdivision and Lot within that row matches a Development and Lot Number within the 'Finished Lot Inventory Summary' sheet.

The formula i am using is:

Any tips would be much appreciated.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!