-
Gantt Print Problem - Can't choose columns to print
Anybody having problems with their "non-licensed" users not being able to select the columns to print in a Gantt view? The "edit" button for selecting columns to print no longer works. I'm wondering if the recent software update has broken this functionality.. We receive an error that says "An error has occurred in the…
-
Forms - request comments and attachments but don't display current
Hi - I would like to be able to create a form in which new comments and attachments can be submitted - but previous comments and attachments cannot be viewed - is this possible? thanks
-
Critical Path Indicator
Are there any options in Smartsheet that would allow me to understand in the Grid View if a task is on Critical Path? Is there a Column type? Formula? etc...? or some type of flag beside just the color of the Gantt bar in the Gantt view? We are trying to filter our projects for Critical Path tasks and our only workaround…
-
Count Unique Values
I have a master sheet that is essentially a list of all the schedules we currently have dealing with projects. Each project has its own project number. All i am trying to do is get a number of the projects we have scheduled to compare to the actual number of projects we have in our queue. Now for the tricky part. Some…
-
Set up a condition so I know a task has more than one predecessor
I would like to set up conditional formatting to highlight tasks that have more than one predecessor. This becomes useful in using reports that do not properly display the predecessors.
-
Simple Sum formula not working
I'm running into an issue where it appears the formulas that I have returning a number are not available for simple math in sum formulas. Any suggestions? For example, I have a column that produces the month a project will close based upon the estimated completion date currently linking in from the individual task lists. I…
-
Conversations — but with groups?
My org used to use the “Send” or “Send Update Request” option from the fly-out menu on each row quite frequently. That feature is now only available to licensed users, I believe, as Smartsheet moves people to use conversations in the comments instead. See:…
-
Countif on Checkbox column type
Hi, I am trying to get the % of tasks complete. The column is a checkbox type. This allows me to get the number as long as all columns are 1 (checked) or 0 (unchecked) =ROUND(100 * (COUNTIFS(ES2:ES36, 1) / COUNT(ES2:ES36))) + "%" I need to add a Count if ES2:ES36 contains only 1 or 0, so if the column is set to N/A then…
-
Gantt Chart Zoom
When I am viewing and printing gantt charts I often need a zoom level in between the default zoom levels available for gantt charts. Is it possible to incorporate more felxibility with how zoomed in or out a gantt chart is? Maybe a slider or number?
-
Consolidate Metrics from multiple existing and new sheets
Hey Everybody, We currently have multiple workspaces for each individual job that we do. Each job will have its own Metrics sheet that brings data from the other sheets for progress. As new jobs come in, new workspaces are created. I am looking for a way to be able to create a high level Metrics sheet that can look at all…