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 December 2016
Discussion List
I need a better way to print/share Gantt charts
Hi, I frequently need to share Gantt charts - in project reports, presentations, proposals, etc. I find capturing the Gantts a real challenge. I know how to print them, but it often spans several pages and is essentially unreadable. I know how to make it fit to one page, but with the grid lines, it's pretty hard on the…
:% Completion Drop Down freeze
We are unable to use the drop-down option to update the % completion of our projects but it allows us to manually update it. It has being like this for about a week. How do I fix it?
Report - sum a column
Hi all, I have multiple budget spreadsheets and a related report which I point to one budget sheet at a time. I can then report on just one month at a time (example: project A, October totals). Is there any way to sum the cost column for the items returned in the report?
SMARTSHEET FREEZE
We're experiencing "freezing" of open sheets for a few seconds when you cannot click on anything. This has been going on for a few days. Anyone else experiencing this? Thanks
Lags and Leads - Proposed Enhancements
There are two elements to Lags and leads that I believe are greatly needed in Smartsheet Projects: 1 - Being able to use elapsed time in Predecessors i.e. +e6h for Paint drying time or +e5d for waiting for approval from external agency etc. 2 - The ability to use percentage % in Leads so that the overlap is based on the…
Need Some Help Nesting IF Statements
Hi everyone, I am trying to use End Date, Duration, and % Complete to calculate the correct color ball in the status column and I am having trouble combining the statements I believe I need (might be wrong with my basic statements also). Here is my thinking: Red – if you are at OR past the end date AND not 100% complete…
Automate Day based on chosen date
Hi users! I have a coloum that the user selects the date for a particular job. The following Column requires that DAY of the week to be selected. Ie: if I choose the date 19/12/16, i then have to maually select 'Monday' from the drop down list. Is there a way to automate that day of the week based on which date I select in…
Web Forms Client Input
I run a construction company and I require information from the client regarding decoration specification, colours etc. I have created a Smartsheet and need to get the client to fill out the information. Screenshot below What is the best way to get the information from the client ? Share the sheet? Only problem is I can’t…
How to use indet and outdent in spreed sheet \ googal sheet.
How to use indet and outdent function in googal sheet \ spreed sheet.
Project Resource View
Project resource view. Is it possible to show all assigned tasks within a single project sheet for a single resource. Managing a master schedule with multiple tasks assigned to resources.
