-
Merged: Conditional Formatting
This discussion has been merged.
-
Conditional Formating on Workflow Emails
As of right now, there is no way for conditional formatting to show on emails that are generated through workflow. I suggest implementing a method to allow this, for example, I have conditional formatting that highlights fields when a specific criterion is met, but when I send that email out via workflow that…
-
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!
-
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…
-
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…
-
Enhancement Request: Allow changes to Column Type when Conditional Formatting is set
If a column is associated with any Conditional Formatting, the column type can not be changed. This is true even if the Conditional Formatting Rule is disabled. This is true even when changing Column Type from 'like' types, for example Text/Number to Dropdown List. This is an inconvenience, minor at best, severe at worst…
-
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.
-
Hyperlink Color on Dark Background
Hi, I'm new to SmartSheet so I may have missed something. When I add an hyperlink on a cell with dark background, is there a way to make the text white or any other color that would allow to read it? I thought the automatic mode would change the color, but it does not let me do so... any ideas? Do I have to stick with…
-
Conditional Formatting on Sheet and Row Level
Dear Smartsheet Development Team, I hope this message finds you well. I am writing to suggest an enhancement to the conditional formatting features in Smartsheet. As a frequent user of your platform, I have found that while Smartsheet offers robust functionalities, there are limitations in the conditional formatting…