-
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?
-
How can I make a "Status" field change "Percentage Complete?"
Hello, I'm wondering how I can sync a dropdown menu (Status Column) to another column (Percentage Complete). Ideally, this function would change the Percentage Complete column to 100% when the status is marked "complete." Thanks in advance for your help with this! - Mike
-
Master sheets - why sheets and not reports?
New to SS. Setting up many project sheets and then want the high level info pulled together onto a master sheet. Videos I've watched say to create a master sheet and link data in from project sheets. Project management webinar I watched has a company that designs/fabricates/installs 10,000 signs per year (complicated…
-
Consolidated Update Requests
When we first had access to Smartsheet, we were able to view all of our update requests on one screen. Did that go away or am I just missing it. Is there any other way to consolidate that information?