Building a formula to connect multiple cells between sheets
I understand that Smartsheet is not automation tool, but would like to make team's work easier without having to enter lots of information manually.
Situation is that that we have two files: pipeline and quote. Once the quote is completed, there is a series of Values, about 40, which need to be called up on the Pipeline sheet. All of those 40 values will always be located on the same column and row of the template/quote sheet.
I am looking for an easy way to connect the 40 pieces of information without manually having to link each of those pieces of information to the cell in the pipeline. I can just link the whole row because I need to connect only certain cells, and their order is different on both sheets.
I've been trying to build VLOOKUP formula for that, but so far I am failing miserably.
Any help or general direction would be highly appreciated. Thank you in advance.
Help Article Resources
Check out the Formula Handbook template!