-
Activity weightage in %
Hi, I want to know whether smartsheet has facility to show activity weightage in %. For ex. I have one main task and 4 sub task. I want provision to assign weghtage to each subtask. Same should be rolled back to main task. Share the information if available. sandip
-
Date Columns - Formats
I fear that I will be out-of-luck here, but we'll give it a try. We're using SmartSheet to layout a timetable for a tricky real estate development project...fairly straightforward stuff. However our cap-x committee has asked to see the chart laid out with days (1,2,3...600,601, etc.) instead of calendar headings. I've…
-
Smartsheet Slow Response Time
The more rows and columns a smartsheet has, the slower its response time. It other words, I am constantly using smartsheet with thousands of rows and columns. As a result, I am constantly waiting for your servers to process and save my work. When can we expect to see better response time? I've posted an image for you to…
-
'Conditional'/Multiple Predecessors
Is it possible for start date of a task to be based on dates tied to one of two other tasks? E.g. Task 2 must start not more that 10 days from completion of Task 1. Under normal circumstances, this allows task 2 to start not more than 10 days from start date of task 3. If start date of task 3 must be accelerated, however,…
-
Resource Views - limit reports to a specific workspace
Hi - In "Resource Views", is there a way to create a view which limits (or filters) the allocation information to just coming from one workspace? I don't want it to pull data from my "sheets" folder or see data coming from "other sheets". I had some copies in my sheets folder and those got pulled into the view ...
-
OPPM_One Page Project Manager
I am new to Smartsheet I am a big fan of communicating task and project status via a single page. Does anyone have experience of using Smartsheet using the OPPM format?
-
Remove Parent data automation when Child dates are entered
Hi all, When using date columns, Start/End the Parent row auto-updates with the earliest and latest of its Child rows. Is there any way to turn off this function? Thanks, Josh
-
Contingency duration based on predecessors
I was wondering if it is possible to create a task whose duration is determined by two predecessors, one from backward planning and one from forward constraints. I would like to use this, among others, to show dynamic contingency periods in my project. Let's take the simplest example, a project with the following three…
-
IF Statement and CheckBox
I am trying to get a sum of % completion based on a Checkbox. For example, if someone checks off 3-4 of the boxes, and I know the weighting for each box (as shown in the IF statement, I would like to have a sum at the end as per the screenshot. The problem is, the sum isn't working. Any thoughts...?
-
Can I create a If Then statement using a date in smart sheet?
I am trying to get a summary of duration for a particular resource within a particular month in smartsheet. This is unfortunately so that I can then input the hours into a custom ERP that lacks any intuitiveness. How could I do this? Here is an example Resource . Duration . Start Dates, End Dates LD 2 days . 8/29 8/30 AD 1…