I am looking to understand what the correct syntax would be for a formula for a Google Spreadsheets that would use the IF THEN
function inside of an IMPORTRANGE
formula.
I want to import all of the part numbers from column C
of workbook 1, sheet 1,
and stick them into column C
, sheet 1 or workbook 2
I would like to see about a formula that would only pull the cells that have content, while also leaving all the additional blank cells behind.