-
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…
-
Conditional Formatting Based on 2 Different Cells
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…
-
Using AND and ISBLANK in nested IF statement
I am responsible for tracking my companies incoming inquires and quotes. Did we get back to everyone, quote them, did they accept or decline the quote?, etc. As part of that I sweated out the following formula, =IF(ISBLANK([Follow Up Date]98), IF((TODAY() - Created98) - 2 > 0, IF(OR([Quote Accepted]98, [Quote Rejected]98,…