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…
How do I make my grid view smartsheet to automatically shade every other row a different color background so it's easier to read?
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?
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?!?!?
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…
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…
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…
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!
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…
I have done this in Excel but can’t seem to get it to work in SS. I need conditional formatting to represent the following: EAC Margin < BL Margin BL Margin ≤ EAC Margin ≥ (BL Margin + 5%) (BL Margin +5%) < EAC Margin Tried creating a separate column with a formula using IF. But can’t seem to get the formula to work. I am…
