-
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…
-
Project Rollup Metrics (sum of all project durations)
I have a master sheet that rolls up metrics from my projects for reporting on various KPIs to my leadership. I need to sum duration, but when I link the cell from the sheet it comes over as (ex., 43d). The sum doesn't acknowledge the d, so I am unable to sum the total of all days for a project. Thanks,
-
Project Cashflow
Hi there, I would like to be able to create a month by month cashflow report from a Smartsheet Project (or a number of projects) based on the schedule and Budget Amount entered into each row. ie. Take a standard Project in Smartsheet, which has rows for each task (along with STart and Finish times) and has additional…
-
Compare/Track planned dates vs actual dates
Hello, I would like to find the best way to track our time slippage in projects. Each project (sheet) in Smartsheet is essentially a big timing plan. However, things don't often go to according to original plans, and the dates have to unfortunately change often. I would like to be able to track how these dates changed, so…
-
Attachments
Hi, I am having an issue with being able to upload attachments to Smartsheet. (Both admin and team members) Any suggestions as to what is wrong with the system? Kind regards, Kyle
