Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2016 Posts
Archives for November 2016
Discussion List
Column misalignment
I have had this issue on and off for a few weeks. After using toolbar to make changes to sheet the columns dont line up with the header descriptions. Anyone else having the same issue? Regards Wayne
Adding a numeric value to a cell with a checked box
I'm having a hard time and maybe it's because it's obviously not even possible? I'm wondering if a checked box can also equal a numeric value without adding additional columns. Possible? (Photo referenced below) If so, GOAL: Ex if checkbox is checked in this cell in Column BIGKY then that cell has a value that equals 50.…
Page Breaks
Can anyone tell me if you can insert page breaks in a schedule so that when you print it will print as seperate pages?
removing check boxes from a row
Hi all - this seems like it would be easy but I cant figure it out. I have a spreadsheet with different sections, most rows I DO want the check boxes but on my header rows which are separateing my sectinos I DO NOT want the check boxes but I can't figure out how to get rid of them since they are a column property. Anyone…
Creating a Master Sheet Composed of Dependent Dept Sheets // Sheet Linking // Sub-Sheets
Hi Community - Looking to crowdsource the best method of creating a Master Sheet (think: Company ALL) composed of smaller Department Sheets (think: Marketing, Development, etc). The ideal set up here is that while only I may have access to the the "Company All" the dept heads have access to their respective Department…
refresh
So I have what I hope is a common issue resulting in a simple solution - when I make a change on my mobile app, the desktop "main" sheet doesn't automatically update. The only way I can think of to work with this is to remember to refresh the main desktop sheet. That requires mousing over the side bar "sheet" icon and…
Linking in the Same Sheet
For large sheets, is there a way to link from rows to other rows within the same sheet. For example, I have developed a lirbary of sorts with files that fall into different categories. There are several categories and lots of files in each category. I was thinking I could have each of the categories at the top of the sheet…
Multiple users adding columns
I have someone set as an admin for a workspace, but they cannot add new columns to sheets in there. Can only the owner add columns?
making sub lanes in kanban
Hi everyone. I particularly like the Kanabvan sheet as we can visually see the progress of a project as it moves from one are to the next. However, im looking to see if its possible to create "sub lanes" within lanes to creat a flow path that starts top and ends in bottom and then moves into another lane. Each lane is a…
Rolling Up or Consolidating Divisional Budgets
Fairly new user here. Looking for help in rolling up our divisional budgets into a consolidated budget. I have an income statement budget template for each division which has worked beautifully with callaboraters completing their info. These templates (sheets) are all exactly the same format. I'd like to have a…
