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 March 2016
Discussion List
Notifications - Changes to cell also notifies when cell is created
Currently I have a sheet that set set to receive data from a smartsheet form. That form puts the data at the top of my sheet. I have a checkbox that is checked by default in the form [column name: New Employee]. I also have an alert that says if column "New Employee" changes notify me right away. Now at this point I have…
Children Selection Using Keyboard
I usually need to select all of the children to copy and I have to use the shift+mouse to manually select them. Keyboards should be faster, but in Smartsheet, Ctrl+Shift+ArrowUp/Down will select past the parent or to the rest of the sheet if there's no blank rows between each parent. Can the Smartsheet team update the…
How can I generate a project planned vs. actual S curve in smartsheet?
I have a project plan with task name and timelines. I am using the gannt chart template. i want to see an S curve: Planned vs. Actual. Wondering if there is an automated way to generate that?
Last Column not available for view. -- recovered!
I have a large sheet (48-50 columns by 80 rows). I can not see the last column. It has a formula that displays either "not done" or "done". I use it to highlight "done" rows in green. I was working on another indicator and wanted to access that column and couldn't scroll over to it. Have I met a limit on the width of the…
Split-screen View to compare sheets
In other programs there is a split-screen view or arrange windows in order to compare two documents. Other than opening two different Smartsheet windows (and, subsequently, opening a different sheet in each window), is there a way to compare sheets? I have two versions of a sheet (where I am using data from one to update…
Roadmap 2 cents
I looked over the road map for Smartsheets and it looks like the most effort is being put into expanding and integrating with other products. It seems that based on the comments here that there is a lot that could be improved or added to what already exsists and that maybe it is time to circle back around and focus more…
Hours don't translate over correctly to Gantt Chart
I'm entering 2 hrs in duration, but over in the gant chartt, it shows 2 days. advice on how to enter/view this corretly?
Project automation - update start date when task 100% complete
Hi, I am new to Smartsheet. I have a project that has multiple tasks and dependencies. If I have a task that is completed ahead of time and I mark the '% Complete' to 100%, I would like the dependent tasks to update. (I have the Dependency Settings enabled in Project Settings) For example if a task is due to finish on 6th…
Reporting tool for invoicing
I run a consulting company and would like to build a sheet where the staff can report on the time they have worked for certain clients. We invoice AM and/or PM blocks, not per hour. I have my clients in a drop down box. How can I make a summary sheet that links to the individual consultant reporting sheets in order to…
Microsoft projects
I am intersted to get smartsheet but would like to know if any body has used it with Microsoft projects . as my projects are been managed by MSP and I would like to link it with smartsheet