-
Conditional formatting in new views, now generally available!
January 26, 2026 Conditional formatting allows you to automatically update the appearance of cells or rows when specific criteria are met—for example, highlighting a completed task in green or bolding a flagged row. Previously, creating or managing conditional formatting required switching back to legacy views, as this…
-
Number Color Conditional Formatting on Dashboards
I would like conditional formatting by color on "number" displays on dashboards.
-
My conditional formatting is not showing consistently in my reports, what did I do wrong?
Hello, So I have several conditional formatting rules set up and after adding a few more that were needed for my team, some of the formatting is not showing on my team's reports for all the rows. Example: I have a format rule for a drop down list column where when the word Need is used, that cell should turn yellow. The…
-
Timeline View Conditional Formatting Color Not Updating in Real time and requires refresh of page
I have a grid sheet with formulas and conditional formatting set up so that when the Status of a row/task changes, the row color and icon update accordingly (e.g., when Status = “Staged,” the row turns yellow and shows a yellow icon). These colors have always carried over correctly into Timeline view. Previously, if I…
-
More Color Options - Make Custom Colors in Conditional Formatting
I would love to have the ability to make custom colors or use color hex codes in the conditional formatting window.
-
Pull date from text string for conditional formatting
I have a text string column that always ends with "by [date]" on a sheet that someone else manages. They want to keep the text in that paragraph instead of using a separate date column, but they want conditional formatting on the date column… I have a formula that pulls the text value from the Next Deliverable(s) column:…
-
Changing Colors - Card View
I can't figure out why the colors aren't showing up in card view with conditional formatting. It's working fine on grid view and table view. I have tried coloring everything or just the status, and "high priority" items should have red text. When I go to board view, it tells me to go to card view to change the conditional…
-
Conditional Formatting Based on Min & Max Columns
I have a sheet that shows the stock of all promotional items across several locations and I'm trying to set up conditional formatting to highlight the cell if it's less than or equal to the min amount. I can do this manually for every row but wondering if there's a way to do this similar to how excel & Google sheets have…
-
Conditional Formatting
Hi all, and thanks in advance. I was trying to do a Conditional Format on this. I know how to do it in Excel, as I would use a formula, but I am having trouble with only the dropdown choices available. Okay, I want my CF to check if the 2 circled columns are the same. This instance does not show, however basically I am…
-
SIMPLE Conditional Formatting is not Working
I have never had issues with conditional formatting, even when formulas were required. This one is simple, it is NO formulas, just based on the user's selection from a dropdown that appears in this sheet. The first screenshot shows the column example. Most are declined here, and those should be highlighted ORANGE based on…
-
why are theses column not being colored not by conditional format or by me ?
-
Merged: Applying Grid View Conditional Formatting in Bulk
This discussion has been merged.
-
RACSI/RACI Matrix with Conditional Formatting
Does anyone have a solution to easily set up conditional format for a RACSI/RACI Matrix without having to clone each RACSI option and setting up a conditional format for each role (in columns)? Like a formula or selecting multiple columns with the same dropdown? I created a traditional RACSI matrix for a customer but got…
-
Highlight new row
I have an automation that copies over a row each time it meets a criteria. is there a way to highlight the newly added row in the destination sheet by automation/conditional formatting?
-
Numbers in Form
My Regional Number Settings are: 2 500,00. In the Form, I have a field that only allows numbers. Form input rows to the worksheet. Unfortunately, the Form doesn't allow the "," entry. In the Form, the number must be entered as 2500.00. However, such a value transfered to the column (with setting as Text/number) in…
-
"Does Not Contain" Conditional Formatting
It just came to my attention that the custom criteria dropdown for Conditional Formatting has a "contains" option, but not a "does not contain" option. Also, the "Apply to format when condition is NOT met" button [which would solve this problem] only exists on the "select from a list" menu and not from the "define custom…
-
Sheet Timeout & Performance Issues – Identical Copy Works Fine, Original Doesn’t
Hi everyone, I’m currently working with a Smartsheet that includes: ~30 conditional formatting rules ~1700 rows Multiple columns with INDEX/MATCH formulas Numerous columns with regular @cell formulas Numerous columns with various types of data Two Data Shuttle workflows that update dropdown values in two columns Multiple…
-
Change formatting based on new date input
Background Currently, I am tracking whether a person attended a visit on a certain date and color coding for easy reference. Each row represents a person These dates are at regular intervals, so I'm using a column formula to calculate what the dates should with each each column referencing the column before it as long as…
-
How do I get my datasheet to show the months requests were opened and closed
when my request tracker sheet's input is in calendar format? Current set up is as below, and I'd only like to use data from column A & B to ensure better accuracy in the data sheet:
-
Conditional formatting randomly not working
I am trying to determine why the conditional formatting has stopped being applied to random cells. I have the settings set to change as we change the drop down option. However there are random cells that the background formating is not applied and you see the words. It is random. I have cleared formating. Deleted the…
-
Conditional Formatting for Proof Approvals
Would be great if once all parties have approved a proof (using the built in proof approval feature), conditional formatting can be applied to a row. This way we don't have to go in and manually check the status on who has approved each line item. I haven't found a way to do this and have viewed a lot of forums. If anyone…