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 pro…
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.
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 th…
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 p…
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,…
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 o…
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 …
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)…
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…
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 ori…
