-
Cell Linking
I have watched many videos but cannot seem to master the cell linking between sheets. I've tried multiple ways but never receive the results I'm looking for. I have a project on a sheet Named Eblasts and it has subcategories of Months of Year and then Tasks subcategorized under that. I would like to link the whole Eblast…
-
Row showing sprints at the top of the Gantt View
Hi Does anyone know if there's a way to add a row directly underneath the date row showing sprints? So one row that shows x weeks for sprint 1, sprint 2 etc, directly under the dates where they sit? This way when you look down the Gantt Chart you can see what sits in each sprint by looking at columns instead of rows. I…
-
Resource Allocation in Manufacturing
Hello, I am curious if anyone has tried to use Resource Allocation for capacity planning in manufacturing. Our projects are long term releases against blanket orders and I would like to use the Project Sheet to view where Production/Manufacturing resources are over-allocated and prove the need for additional staffing or…
-
Formula Predecessor Help 2...
I could use some help. I've implemented J. Craig Williams' predecessor solution allowing notifications based on the predecessor being complete for a given task: 1. Create a column to get your Row# [RowID] In the first row, put a 1. The second row, use the formula =RowID1 +1 and copy that to all the other rows. 2. Create a…
-
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?
-
Restrict a user's access to Dashboard only
I am new to Smartsheet but learning fast. We are starting a project to use Smartsheet for client onboarding to our software. I intend to create a client-facing dashboard but would like to restrict a user's access so they cannot click on the Home tab which they have no reason to view and is just a place for them to take a…
-
Gant Chart Time Dependencies - Hours
Please let me know if anyone has figured out how to get the gant chart down to hours. The minimum that I have seen is at days and then it goes to weeks, months, and years. We have a project that will have dependencies on certain days that go down to the hour.
-
Auto-populating a sheet with filtered data from another
All, I'm hoping someone can suggest a solution. I am trying to reduce the amount of time spent re-entering data about upcoming bids from one spreadsheet to another. My company has a master list of bids over the fiscal year and every week my boss produces a separate sheet of just the upcoming bids that he can then use…
-
PERT: +/-2 sigma (Probability 95.46%)
Good Day All: How do I take the following excel formula and use it smartsheet to get the same results Excel formula =$G$30-2*SQRT($I$30) Results: 1.33 Smartsheet Formula =$Expected$26-2*SQRT($Variance$26) Results: UNPARSEABLE I tried using ^2 for square root but still receive the same results. Thanks
-
Report with resource allocation rollup
Hi, I am looking for a solution where I can roll up resources by their allocation at a portfolio level. The resource view only shows me the rollup for licensed users. However, we have users that are allocated to projects that are not necessarily licensed to create or edit sheets. They are ok with read only access. I…