Need help with adding additional reference sheets to this formula.

Joyce W
Joyce W ✭✭
edited 05/09/23 in Formulas and Functions


I have a sheet name "Process Issues" with a series of information in this sheet. I have 3 other sheets named: Deposit, Lending, Payments. I have set up that when the project ID from the "Process Issues" sheet, is entered in the applicable deposit, lending and payments sheet, that the fields are auto populated from the "Process Issues" sheet. This formula I have working.

I have a "Notes' column in each of the deposit, lending, and payments sheets. I want write a formula that would copy over the notes back to the "Process Issues" sheet based on the project ID from the Deposit, Lending and Payments sheet.

I am now stuck on this formula and I am only able to get the formula to work with just one sheet (lending), and I can't get the deposit and payments in the formula. How can I add the other two sheets into the formula? Any help would be appreciated! Thanks!

=INDEX({Lending Summary Data}, MATCH($[Project ID]@row, {Project ID}, 0), MATCH(Notes$1, {Lending Summary Header}, 0))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!