Formula Help: Cross-Sheet lookup to validate & input information

Steve Bertram
Steve Bertram ✭✭✭✭
edited 06/03/20 in Formulas and Functions


trying to have a cell in one sheet look at another sheet for its information. I need to check the value in a cell and if it equals 1 then copy the information from a different cell in the same row (in this instance column 1 in the range 'Design Phase Data Range 3'. However I keep getting the 'unparseable' error and can't see why. Grateful for any pointers.

=IF(VLOOKUP({Design Phase Data Dsgn Prnt}@row =1, {Design Phase Data Range 3}, 1,false))




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!