-
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…
-
Referencing checked state of Flag symbol using formula
I want to use a Flag column to mark high-priority tasks and calculate a reduced lead time. In a Due Date column I use a formula to add 7 days to the Received Date. I want to change the formula so that it adds only 5 days IF the flag is checked. I can't seem to find out how to reference the value of the flag cell, though.…
-
Business Resumption Plan
Does anyone currently us Smartsheet in their Business Resumption planning?
-
Contact list
Hi, Our sales representatives use the form below to report their customer activities: https://app.smartsheet.com/b/publish?EQBCT=7661b84339764a62ad8a0e6f8d803770 I need to make a contact list connected to all the sales representatives sheets so we can get a complete contact list with all sales activities. Does anyone now a…
-
Auto-numbering defect tracking
I am using Smartsheet with several vendors who are testing and comparing legacy solution with new product. I have a checkbox column setup to identify potential defects. Can I have a column that only auto-numbers on a condition that a defect has been identified?
