Conditional Formatting

Discussion List

  • Change cell color based on date from another sheet
    In Formulas and Functions
    Hello! I'm working on a project overview sheet for many overlapping timelines. I'd like to make it so that if any of the projects have the date that the column is named that cell highlights or changes color. So, for example, if project 1 t…
    Answered - Pending Review
    44 2
    Answered - Pending Review 44 views 2 comments Most recent by Nicolette Marinos Formulas and Functions
  • Show % progress on bars in Gannt view
    In Using Smartsheet
    Been searching and can not find any clear answer to this so ill ask (maybe again). Is there a way of presenting the % progress within the bar of a task in Gannt view as it is as default in MS Project for example? It could be enough to ha…
    713 5
    713 views 5 comments Most recent by Genevieve P. Using Smartsheet
  • COUNTIFS Issues
    In Formulas and Functions
    I am having problems getting COUNTIFS to work. I have two different formulas I am trying to set-up in different columns. I would also like cells that return as zero to change to blank. Does anyone know how I can fix my formulas and also se…
    Answered - Pending Review
    42 1
    Answered - Pending Review 42 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Default view when a user opens a sheet
    In Using Smartsheet
    Hello! What is the default view for a unlicensed user when they open a sheet? (In regards to collapsed and expanded rows) Is it the same as the last way they viewed it, or how the last user had viewed it? Here is the specific question from…
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Genevieve P. Using Smartsheet
  • Mark Duplicate value
    In Formulas and Functions
    Hello team can someone suggest a simple way to mark cell (or rows) that one of the columns with Duplicate value thanks in advance oded
    2738 18
    2.7K views 18 comments Most recent by Genevieve P. Formulas and Functions
  • Change Status if Date Completed is not blank
    In Using Smartsheet
    Our team has a sheet to track all of our tasks - who it's assigned to, when it's due, date it's completed, the status (requested, assigned, complete), etc. We have people updating the "Date Completed" column, but forgetting to u…
    72 3
    72 views 3 comments Most recent by Mike Wilday Using Smartsheet
  • Workflow email content based on conditions/critieria
    In Formulas and Functions
    Hi All I'm very very new to SS (just got a license today) and I've been included in a team to improve the notification process to our wider audience with key information to help them complete actions quicker with minimum TLDR! Is it possib…
    Answered - Pending Review
    25 1
    Answered - Pending Review 25 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Can I setup conditional formatting based on a time function?
    In Using Smartsheet
    Hello! Is it possible to setup conditional formatting based on a time function? For example, I want a cell to turn red if it hasn't been updated by 12noon. Or, I want a cell to turn red if the current time is after 2pm.
    Answered - Pending Review
    51 5
    Answered - Pending Review 51 views 5 comments Most recent by Paul Newcome Using Smartsheet
  • Counting checkbox's for children without counting the parent
    In Formulas and Functions
    OK I am new to building formulas like this and everything I keep trying gives me errors like "UNPARSEABLE" and "BLOCKED". How would I set up a formula for this? If the "Is there a color image?" box then the r…
    Answered - Pending Review
    11 2
    Answered - Pending Review 11 views 2 comments Most recent by Natasha Henman Formulas and Functions
  • API Conditional Formatting
    In API & Developers
    Hi -  It sure would be nice to have the ability to update conditional formatting via the API. I see a thread from 2016 - is this something that the dev team could look at?   Many Thanks, Sean  
    102 2
    102 views 2 comments Most recent by Greg Caine API & Developers