-
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…
-
Settings for Checkbox Column
How do you change the setting for the checkbox column? I want the whole task to be crossed out if the checkbox is checked as done. I copied this from an old Smartsheet account and that setting didn't carry over. Thank you!
-
Rolling up Conditional Formatting
Smartsheet Community, I have a normal project in which we have tasks that sometimes go past due. Currently I have conditional formatting set such that if the task is not 100%, and the due date is in the past, that whole task row turns red. My question is how do i get that past due task (red) to filter up and make the…
