-
Conditional Formatting Issue for column formula
Hello all, I am having an issue trying to use what should be 'basic' conditional formatting for percentages in a column in my sheet, where there are no colors being displayed as intended. Green = 55% or below Yellow = 55% - 109% Red = 110% + The column the cond formatting is referencing is using a formula - I wasn't aware…
-
COUNTIF formula between date range
I'm trying to do a countif formula between a specific range of years, while referencing from an alternate sheet. This is the sheet with all my data (of course, just a small example) And this is the range within which I'm trying to work. For 1976-2000, the formula I have is =COUNTIFS({Game Design Range 2}, >=1976), but…
-
Smartsheets Malfunctioning After January Microsoft Edge Update
Hello All, Is anyone else experiencing issues with smartsheets on their microsoft edge browser? After the lastest update my grid is no longer picking up the color conditional formatting. This color conditional formatting works on the mobile app and on google chrome but does not work on the desktop app or microsoft edge…
-
Dynamic View does not show Conditional Formatting in Blank Cells
Dynamic View seems stumped by blank cells and doesn't properly apply conditional formatting. In the screenshot below, each of the white cells should have a color. As a workaround, we colored the entire column in the source sheet, which seemed to work initially. But then we realized that conditional formatting to change the…
-
Highlight all blank fields without having to set Conditional Formatting for each coloumn?
I have users asking to highlight any and all blank fields in Smartsheet without having to set conditional formatting in each column. Is this possible? Only solution I am aware of is setting conditional formatting to each column, and there are sheets with well over 50 columns.
-
Allowing users to apply "Names" and "Descriptions" to conditional formatting rules.
Hi, my team's resources often utilize a LOT of conditional formatting to help highlight certain things, spot where data is missing, etc. These resources are also shared across many teams and people. Our conditional formatting rules lists are often extremely long with similar-ish formatting for different rules. Being able…
-
Conditional Dropdowns functionality, not available yet?
Hello everyone, I’ve been working extensively with Smartsheet and noticed a significant limitation that has been discussed for years but still hasn’t been addressed: conditional dropdowns. Here’s the scenario I’m struggling with: In Column A, the user selects an option (e.g., "Option 1"). Based on that selection, the…
-
Is there a way to apply conditional formatting in Dashboards?
Is there a way to apply conditional formatting in dashboards? Specifically looking to apply conditional formatting to pie charts. For example, I’d like anything between 10 and 19 to appear in red, and anything between 20 and 24 in green.
-
How can I use index match + either another index match or an IF statement to pull Data from multiple
How can I use index match + either another index match or an IF statement to pull Data from multiple sheets? In my case I have 3 sheets: Sheet 1 - Current Project List - consists information that track active projects. (each Project has a unique project code) Sheet 2- Closed Project List - consists of previous years…
-
Formatting in board view: headers and dividers
I have a use case where I need users to update existing information and there are a lot of columns. It would be great if I could have the same functionality from Forms in and open card or board, like adding lines or text blocks (with formatting options) to break up different sections, adding or removing certain fields,…