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
Creating Pivot Table-like summary
I'd like to create a sheet similar to an Excel Pivot Table. Can't seem to find a way. I've tried report but that just lists items. I want to count items by status in one simple view. Thanks. Wayne
Feature request: auto sum of children (non system columns)
Hi, In many cases we have columns with a sum of the childrens. If we make some more subtasks and somebody forget to add the "=sum(children())" we miss the subtask in the calculations. Is it possible to create a special column attribute to change a regular in a column like a system column, they can auto sum/calculate the…
Gantt Chart has some lines that are all gray
Hi, I am using a fairly simple Gantt chart. it has 15 task rows in it. All tasks contain a Start and Due Date. The only indentation I'm using, is that I've got a "Project Launch and End Dates" row as my first row, and I've got all 15 rows under that, indented. The first 6 rows of the Gantt chart look normal. I see the…
New Filter Options
I am so excited with this new addition of Filters. My questions if you set a filter and schedule it to email from that filtered view will that filtered view be what is sent each time according to the schedule. Example I have the sheet currently filtered for Last 7 days entries. i have set it up to send to designated…
titles in workspace and sheets are not centered ...
... and they are being cut off by the bottom of the cell. Help! I've already made sure my browser isn't zoomed, so I'm view at 100%.
Card View Templates - formulas are missing?
Hi All - I am excited to implement the card view into one of our pipelines. I am basing this off of the "consulting pipeline sample" shown on the homepage of smartsheet. However, when I bring this template in, there are no working formulas for creating totals of the lanes. Am I missing something? Thanks Jef
Can you concatenate in SS?
For example: Column A says "John" Column B says "Smith" Can column C read "John Smith"?
Web Forms
I currently have a web form that a user submits when they require time off. I am using a contact list for the name field. When a form is submitted I email the manager. Once she get it she either approves or not. If she approves I want an email to be automatically sent to the user. This is working but I'm afraid if the name…
Sort Children without affecting Parent Row
Hi everyone Happy Friday-eve! Is there a way to 'sort' Chidren only. I have a small but important Inventory list - Parent Row reflects Brand - Children reflect actual equipment. I then also have GTrandchildren to show when Children (equipment) have been out on loan and have returned and the current status. I'd like to sort…
Starting a new PMO with smartsheet
My company currently does not haave project management. I have graduated from school and have been put to the task of opening a new Project office within the company. We have a ERP system in the company but they do not utlitize it for what its truly worth. I have picked smartsheet as a third party software to use for my…