-
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…
-
Link to another sheet with Function
Hello, i'm newbie for using smartsheet, May I know how make a link to another sheet using Function? Example: I'm created 3 Sheet 1. Sheet A --> Column Volume 1 = 30 2. Sheet B --> Column Volume 1 = 20 3. Sheet C --> Column Volume 1 is SUM of Sheet A Volume 1 + SUM of Sheet B Volume 1 How make do that, need your advise,…
-
How can I link Columns to update?
Hi, If I have a column named "Status" and within that column there options from a dropdown to select Open, Closed or Denied, once I select Closed or Denied, can I on the same sheet over in another column named "Date Closed" can I have the current Date entered in and that row is closed. Is this possible and if so, how do I…
