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.
Discussion List
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…
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.…
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?
ColdFusion and SmartSheet API
0down votefavorite I'm attempting to call the smartsheet.com api and read the JSON data from a list sheet request. Im new to API's so I'm certain I'm missing much with my code. Here is what I have so far: <span class="tag" style="border: 0px; color: #7d2727;"><cfscript></span><span class="pln" style="border: 0px; color:…
=SUMIF across all children / grandchildren
Im not a power user but im looking to build out a bidding teplet for my shop. I have a lot of info spread across many children / grandchildren catagories. Heres what Im looking to accomplish. Itmes - Animals - - Cat - - - Brown 2 - - - Red 4 - - - White 1 - - Dog - - - Brown 4 - - - Red 2 - - - White 6 - - Fish - - - Brown…
Card View: Show Column Name as Label
Our workflow includes multiple check boxes in a row. In Card View we loose the at-a-glance review of the task without the check boxes being labeled. It would be a benefit for many of the column types to include what is being identified.
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…
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
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…
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…