-
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?
-
Enhancement Request: relative addressing for cell linking in sheets, reports and sights
It would be great to be able to use relative addressing in cell linking between sheets and links in reports and sights instead of the fixed linking as currently implemented in Smartsheet. Why? We use Smartsheet for project management and have a set up a standard workspace which contains set of sheets/reports and sights…
-
Dates Don't Act As Dates if Linked from Another Smartsheet
In short... if I pull a date from another sheet using "Link from Cell in Another Sheet", I can't do formulas off that date. I've verfied that the columns are formatted as dates. [Opening Date]1 is linked from another Smartsheet. I want to add 180 days to the [Opening Date]1. [Opening Date]1 = 08/22/82 Here's what the…
-
Contacts and Web forms
Hi Everyone, I am relatively new to smartsheets and there are two things I have been trying to work out adn for the life of me can not find the information to show how its done. The first is having a field aut populate based on picking a contact e.g Contact name = Gary Bee then the next cell should auto popolate with Gary…
