-
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…
-
Sheet Schema & Report Schema Documentation
Hi, I would like to recommend the following enancement. Please could the be a way to export as an Excel or Google sheet the Sheet Schema. This should contain all the information and properties of the sheet, As per the Properties Dialog box from the Sheet menu Plus all Field: * Column Name * Column Type * List Items * Also…
-
How to calculate schedule % updates in Smartsheet
Hi, I use smart sheet for tracking my project progress. i would want to add one more column similar to % complete to calcuate my schedule percentage based on the number of days complete till date divided by duration. i added a column with percentage updates as per schedule however, these percentages do not roll up to the…
-
Test if cell contains value from list
I have a task list that includes tasks by customer name. Due dates are formula-controlled by an offset from an entry date. Certain customers of ours receive "red carpet" treatment, which requires me to recalculate the due date manually. I would like to try the following automated solution: Maintain a separate sheet with a…
-
Pulling drop-down menu values from another sheet
I am trying to create a web-based order form. The item that people would be requesting is seperated into categories and then numbers. E.g. Category A Item #0001 Item #0002 Item #0003 Category B Item #1001 Item #1002 Item #1003 Item #1004 I have these items listed in another sheet and would like customers to be able to…
