Data from one smartsheet to another
What is the best way to pull multiple columns of data from one sheet to another? In sheet "A", I have a unique number. When that unique number is keyed into sheet "B", I want to pull the next 20 columns of info associated with that number into sheet "A". I know I can use index/match, but I don't want to have to key a formula for each cell and I can't seem to figure out another way.