I know about the importRange
function to link two sheets, but I wonder if there's a way so that when a cell's contents are imported to the second sheet, the second sheet will autopopulate the corresponding cell with simply an x
and nothing else. So for example, if Sheet1!B2
has a value of “23”, then Sheet2!B2
will appear as x
.
(I'm not familiar with JavaScript or Google Apps Script so any coding examples would be highly appreciated.)