Conditional Formatting

Discussion List

  • Conditional Formatting
    In Formulas and Functions
    I've tried out the conditional formatting and am unable to show different colored backgrounds for different future date conditions. As an example: I want to show the date cell to show green if it is a future date with a Green Background …
    Accepted
    20 2
    Answered ✓ 20 views 2 comments Most recent by Bert Hoffbeck Formulas and Functions
  • Case sensitive COUNTIF
    In Using Smartsheet
    I'm trying to mark duplicates in a particular column per the discussion here: https://community.smartsheet.com/discussion/comment/319478#Comment_319478 My issue is, the column I'm checking has a mix of uppercase and lowercase letters that …
    Accepted
    52 7
    Answered ✓ 52 views 7 comments Most recent by BSADK Using Smartsheet
  • Using a dropdown to pull duplicates
    In Formulas and Functions
    Hello, I have created a "helper" column to help me find duplicate entries within a row. So all of my columns are going to be drop down entries so as to avoid spelling or typo issues. If a person appears in "Faculty on PTO&qu…
    Answered - Pending Review
    4 1
    Answered - Pending Review 4 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • Hierarchy issues
    In Formulas and Functions
    Hi everyone, I have been pursuing the forum but I can't seem to find the answer. For some background, my company had a team that set up our Workspace and sheets. One of my coworkers was also the admin but recently left for another job. I h…
    Answered - Pending Review
    20 3
    Answered - Pending Review 20 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Conditional Sheet Population
    In Using Smartsheet
    Is it possible to use conditional formatting or formulas to suppress unnecessary tasks? And, if so, could Smartsheet adjust dependencies for removed tasks? For instance, we have a sheet to track product implementations; however, some pro…
    Answered - Pending Review
    40 4
    Answered - Pending Review 40 views 4 comments Most recent by Tony Fronza Using Smartsheet
  • CountIf for check boxes
    In Formulas and Functions
    Good afternoon,    Can you do a Countif formula for a column that has checkboxes.....so that you can count how many rows have the check box?   Thanks    
    15176 29
    15.2K views 29 comments Most recent by Genevieve P. Formulas and Functions
  • Formula for Quantifying Importance based on Priority Level and Due Date
    In Formulas and Functions
    Hello, I am looking to create a formula to help prioritizing tasks based on importance and due date. I assigned a value for the priority level as: =SUM(IF([email protected] = "High", 6, (IF([email protected] = "Medium", 4, (IF(P…
    Accepted
    34 3
    Answered ✓ 34 views 3 comments Most recent by Andrée Starå Formulas and Functions
  • Gantt Chart Parent Row Bars
    In Using Smartsheet
    Has there been an update to allow color edit to the gantt chart parent row bars? Thanks - Julie
    Answered - Pending Review
    28 1
    Answered - Pending Review 28 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • How do I make a Smartsheet that keeps track of initials
    In Using Smartsheet
    I'm trying to make a Smartsheet that keeps track of how many times a set of initials appear on a column. I have a Smartsheet now that people can put there initials on when they complete a task but I would like to be able to track how many …
    Answered - Pending Review
    7 1
    Answered - Pending Review 7 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Automation Suddenly Not Working
    In Using Smartsheet
    I have an "Request Approval" workflow I created back in August 2019 that was working perfectly fine until late last week. I can't find any reason for it. Nothing was changed on our end. Is anyone else having automation problems??
    Answered - Pending Review
    434 11
    Answered - Pending Review 434 views 11 comments Most recent by David Horowitz Using Smartsheet