-
Inconsistent Conditional Formatting
Hey Community! I'm wondering if someone can help me out with why conditional formatting is not giving me consistent results. As shown below, I would like to see red text when the Unbilled column is not zero. One section is returning red text for $0.00 and another section is leaving it black (which is what I want). The 3…
-
Conditional Formatting w/ criteria in a row vs a column
Hello, I have a grid with a row at the bottom that has either 100 or 0 in each column. I would like to create a conditional formatting rule that will highlight the column based on data in that single row. Conditional formatting rules look at criteria in columns rather than rows so I am wondering if anyone has come across…
-
how to get the circle quarter symbols to change colour???
Ok so I am using the below symbols with a formula in background to be in different qtrs/ stages of a project.... Background Formula is: =IFERROR(IF([%]@row <= 0.01, "Empty", IF([%]@row < 0.26, "Quarter", IF([%]@row < 0.51, "Half", IF([%]@row < 0.76, "Three Quarter", "Full")))), "") However, I want to change the colour as I…
-
Gantt View Timeline color coded by stages
I am looking to develop a Gantt view that shows multiple colors on a single bar, based on the calendar, and corresponding stage of the project at that time. For example: Project XYZ, single timeline: red during planning stage (Oct 7-14), green during live stage (Oct 15-22), yellow during results review (Oct 23-29), etc I…
-
Automatically updating a super sheet?
I am new to smart sheets and have been tasked with creating a master schedule for our teams. I am working with two different teams on a project and each team has its own schedule. Is there a way that I can set up the team schedules to automatically feed into a super sheet? Ideally, I would like them to identify if an item…
-
Unparseable Error
I'm getting an error #UNPARSEABLE for the following conditional formula that sets Red, Yellow, Green, Blue symbols per combined conditions of [End Date]'s proximity to "TODAY" + Status Condition (Not Started, In Process, Complete): Formula:…
-
Conditional formatting for reoccurring tasks
Hello, I am trying to design a task tracking smartsheet for tasks of varying reoccurrence, i.e., monthly, quarterly and annually. In this sheet, the idea is to use conditional formatting as a means to identify when something is past due (in the past, red), upcoming (in the next 60 days, yellow), completed (green) or in the…
-
Ability to add to drop-down list options in columns with conditional formatting applied.
Idea Functionality: the ability to add options to drop-down lists in columns that already have conditional formatting applied without having to delete and then redo the conditional formatting for the existing options. Idea Use Case: Column titled Status currently has 4 options to choose from and conditional formatting is…
-
Can I conditionally expose a form field based on an earlier entry?
Okay, first attempt at explaining what I want to do.... I have a sheet where I track items (rows) with a multitude of attributes (columns). It's fairly unwieldy so I wanted to provide Editors with a form to submit new items. Current Form: User enters Title and Description (text columns 1 and 2), selects the Category from a…
-
Conditional formatting for error values
Hi, I'm using VLOOKUP for status information from another table. The referenced table sometimes does not have the requested row, so I get back the #NO MATCH error. This does not looks nice, so I was trying to hide from the users and set conditional formatting - if column value equals to #NO MATCH set the font foreground…