-
Master Task List By Resource
We have multiple projects ongoing simultaneously. In each project tasks are assigned to various team members by the managing partner. Is there a way to have a task automatically roll into a master task list for the manager by resource (sort of a pivot table) or a consolidated task list for each resource team member to…
-
No API access to Gantt Fields?
I see in the API documentation that the programatic access of row data in columns of type Predecessor, Duration, etc. is not supported. I'm doing what I've seen many others on this forum try to do; I'm merging several interdependent sheets into one "master" sheet. It need only be a snapshot of the others and needn't…
-
Update Webform URL's included in Folder when Save As New used
We are currently running multiple Projects and have setup a Master Folder with our Process Task lists in using Card View. Within Card View we have links to some Webforms used to capture Data for certain key tasks. The Webform sheets are located in the same folder. When we do Save As New using the Master Folder to Create a…
-
Resource Mgt
Im new to this. If we have one resource alloocated over several sheets and in one sheet/project the resource is required for an extra day, How do we link so that all associated sheets dates are updated? thanks
-
Percent Complete by Cell Color
Is there a formula to determine percent complete of a task based on the cell color? Cells are filled with dates of various steps in a project and once those are completed, the cell is highlighted. I'd like to have the percent complete column update automatically when the cell color is changed. Help, please!
-
Does anyone know what NaN% means?
Hi all, I'm getting NaN% appear on my sheets where that cell is linked to another sheet. The source cell appears OK, and I've tried remaking the link, but no affect. Is this the 2000 links I'm running up against? There are a lot on my sheet.... Regards - Roland
-
Cell Linking Within Same Sheet
Hello - I'm trying to put a summary line at the top of my sheet showing the latest date on the critical path, so that i can view it even when all the sections are collapsed. Is there a way for me, in line 1, to link a cell next to the label "Current Planned Delivery Date" to the cell that holds this data (column=Finish…
-
Work around to formulas across sheets
I am working with 2x sheets - one a CRM, the other a job list. I would like to be able to flag on the Job list when a customer name is entered which is not already in the CRM. In Excel I could use a combination of ISERROR & MATCH to achieve this, however from what I can work out formulas across sheets is not possible on…
-
Linking in the Same Sheet
For large sheets, is there a way to link from rows to other rows within the same sheet. For example, I have developed a lirbary of sorts with files that fall into different categories. There are several categories and lots of files in each category. I was thinking I could have each of the categories at the top of the sheet…
-
Post Trial Review of Smartsheet as an IT Project Management solution
I've been assessing Smartsheet as a viable replacement for MS Project at our office over the last 30 days and I thought I'd share my finding with the Smartsheet community in case somebody else is also doing such a review. I'd also invite Smartsheet to respond to my observations if they feel I've misrepresented anything…
