I know there have been a number of archived discussions around linking an entire column from one smartsheet to another, and that it can't be done. I know that there is a workaround by selecting a column and changing the cell background to white, and then linking the"blank" cells, and this works fine.
I have a sheet with a pulished Form for staff to fill out and register Health and Safety hazards. In this form I have an Auto-Number column that will populate a new value for each new form filled out.
However, if I use the cell background trick above, (ie select 50 cells in a column and change background to white, then link to another sheet), the next entry from the form is added to the sheet BELOW the white background cells!
Any thoughts on how I can get the cells in an Auto-number column to link to a different sheet, especially when the number of entries goes beyond the default 50 rows?