Hiding Columns

Sara Tucker

We have a purchased items tracker sheet for a project.  Is there a way to make the price column visible only to a couple of people and nobody else without using hide/unhide every time I need to see it or use it?

Greg Gates

I can only think of an inelegant solution here, but it should technically work. You could create a second sheet where every cell is linked to the values in your first sheet (see https://www.smartsheet.com/cell-linking if you haven't done this before) with the exception of the price column - don't include it at all.

 

Now that the data is separated into two separate sheets, just share whichever sheet is appropriate with the audience your working with. Your second sheet sans price column will automatically update with whatever changes you make in the original since the cells are all linked, and vice versa.

 

I hope that makes sense! I know it probably isn't the ideal solution, but let me know if you have any questions.

Sara Tucker

Thank you, Greg.  We did have a second sheet, but did not have then "linked."  That would definitely save some steps.  

J. Craig Williams

Be aware that there is a limit of 5000 incoming links to a sheet.

 

Craig