Using data from one sheet to fill in a cell on another

A.Foust
A.Foust
edited 12/09/19 in Formulas and Functions

I need a cell to populate based on a cell in another sheet. If sheet 1 contains the same number as sheet 2 column 1 then print notes from sheet 1 column notes else leave blank. This is what I have so far =IF(HAS({Sheet 1 Column 1}, [sheet 2]1), {Sheet 1 notes}, " "). {Sheet 1 Column 1}  Refrences the entire column is sheet 1. This returns an invalid column value. Sheet 1 column 1 is a drop down and sheet 2 column 1 is not. Sheet 1 is populated by a fourm so it will not always be in order like sheet 2 will be. 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!