-
Conditional formatting for Reports
The ability to apply conditional formatting rules from within a report would be huge. Having to modify the Source sheet for a specific report doesn't seem to be very efficient.
-
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…
-
Timeline View: conditional formatting turns everything gray?
When using the Group feature in Timeline View, I appreciate how each group is given its own color. However, I would like to use conditional formatting to color bars a different color when a condition is met. However, when testing this, every time I use any type of conditional formatting, it turns the entire timeline view…
-
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:…
-
Delete or Clear all conditional formatting
It would be great to be able to check all the conditional formatting for a sheet to deactivate or delete. There have been times where a sheet has many activated or disabled that prohibits fields from being changed because they have a conditional formatting (this is awesome btw). If there were an option to delete all (or…
-
Conditional Formatting - multiple columns
Hi All, Hope you are all safe. Is it possible to apply conditional formatting to multiple columns (same condition). I have data in 10 columns. I want to highlight cells where the value is not equal to 0. Currently I have to apply conditional formatting to each column separately (cloning the rule). Is there a faster way?…
-
How do I apply conditional formatting to a single cell?
Hello, How do I apply conditional formatting to a specific cell? For the example below, when I click on the "B/C" check box, I only want to highlight the B/C within that row and not that column. Wasn't sure of the best way to do this.
-
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…
-
Conditional Formatting - One rule on multiple columns
Hello, To make our Smartsheets more legible when used for input requests, we use conditional formatting. For example, if we have a table used for percentage-splits with 12 columns and 100 rows we generally pre-populate these inputs where we can with formulas. If the formulas show 0%, it becomes messy fast. To clean it up,…
-
Solution for extreme amount of conditional formattting
Hello!!! I have a scenario that has an extreme amount of conditional formatting requirements. if completed, the sheet will have over 10,000 conditional formatting rules. While hear there are not limits to the amount of rules, at 1,800 the conditional formatting dialogue box really doesn't want to open any more. Has anyone…