-
Conditional formatting broken in table view?
I set up 3 CF rules across 3 columns. Above 60 is supposed to be green, between 30-59 is orange, and below 30 is red. I see no orange, AVG FPS column is not formatted and working at all, and some random columns aren't formatted. I also do not see "equal to or greater than" and "equal to or less than" as an option. What's…
-
How to restore conditional formatting, parent child relationships, and formulas?
Hello, I am trying to restore sheets to exactly what they were, with conditional formatting, formulas, and parent child relationships intact. Is there any way to do this? I am not a software developer, but I would very much appreciate any help the community can give! Thank you!
-
Urgent help please! How to restore a sheet exactly as it was?
Hello! I need urgent help please! Is it possible, either locally on Smartsheet or with a third party platform, to restore a past version of a sheet to an identical format? I have tried the local Smartsheet backup, ProBackup, and am troubleshooting Fluentpro Backup. All have trouble with parent child cell relationships,…
-
New Table View - Format Rules buggy
I just started using the Table View for lists of contacts. I added a Format Rule that would highlight the entire row (except the Email Address field) if the Email Address cell is "blank". A second rule highlights just the Email Address cell itself in a slightly darker color if Email Address cell is "blank". This gives a…
-
Conditional formatting for dropdown with multiple options and OR condition
Hi experts, I have a problem with a conditional formatting rule not performing as expected. I have a dropdown field called "Transit country", and multiple country options can be added from a list (not blurring out the actual options as I'm sure we're all aware of current travel concerns). I've used Contains as it's…
-
Conditional Formatting on Task/Outline Level Formula
I want to format rows based on the Outline Level. e.g. 1 = a darker color, 2=lighter, 3=lighter than 2, etc. I am using a formula to calculate Outline level: =VALUE(COUNT(ANCESTORS([Task Name]@row )) + 1) However conditional formatting is not working. What could allow this to work? Thanks so much!
-
Merged: Conditional Formatting
This discussion has been merged.
-
Connecting Automation to conditional formatting
I am trying to figure out a way to attach automation to conditional formatting. For example, I have 4 columns, with the last one being a checkbox or another standardized trigger. I want to send out a notification that a row has been added, only when the checkbox in the last column is clicked. I set that up already because…
-
Merged: Line Attachments as Condition in Automations
This discussion has been merged.
-
Number Color Conditional Formatting on Dashboards
I would like conditional formatting by color on "number" displays on dashboards.
-
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…
-
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 ?