-
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?
-
Clone Columns including Conditional Formatting
I have a Smartsheet that shows the status of an item by date and I'd like to be able to copy or clone the column with all the conditional formatting. Is there any way to do this?
-
Calculate % complete based upon start and end dates?
Hello, does anyone know how to calcuate the % complete for a project based upon it start and end date? I have projects where my resources are "consulting" and I'd like to have a way to see the % complete of the project when I roll it up in a project overview dashboard. I tried using the traditional "yearfrac" formula…
-
How can I calculate the percentage a resource is allocated to each project?
How can I calculate the number of days or allocation percentage a resource is assigned to a project? What I'm trying to understand is the percentage a resource is allocated to a project so I can track the total in a master project list. For example, if a resource is assigned to 3 projects and they are aloocated 25% per…
-
Shade every other row in Grid View
How do I make my grid view smartsheet to automatically shade every other row a different color background so it's easier to read?
-
Why no Parent() object in Formulas?
I would like to default a value in child row based on a column value in the parent row. Meta-Code: IF Parent()[Column Name]='valueX' THEN Child()[Column Name]='valueX' Can someone walk me through the syntax for that?
-
changing text removes formatting???
Hello! I have a highly fomatted sheet with lots of rows of different colors, font sizes and also a few conditional formattings elements. Somehow, when I change the text in the cell, all of the color formatting is removed, and I can't add it back in. I've tried multiple browsers and nothing is working! Help please?!?!?
-
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…
-
Best practices; optimum template design for pulling/pushing distilled info from a sheet
Typical project management templates are not designed to easily get a distilled summary of important points. I am wondering if these is a template out there that would allow for easily pushing out or pulling from a sheet the following. If this info is in form of a symbol (Harvey Ball symbols for example) instead of numbers…
-
Web Forms
I currently have a web form that a user submits when they require time off. I am using a contact list for the name field. When a form is submitted I email the manager. Once she get it she either approves or not. If she approves I want an email to be automatically sent to the user. This is working but I'm afraid if the name…
