-
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…
-
Dynamic View - 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…
-
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,…
-
Does anyone know if it is possible to copy conditional formatting from one sheet to another?
I see some posts from a few years back. We have Bridge, would this be a solution?
-
Global Conditional Formatting
Hi, is there any way to have Smartsheet apply conditional formatting to any cell that matches a criteria? Let's say I have a sheet with 50 dropdown columns containing "Pass", "Fail", "Remediated", or "N/A". I want any cell that contains "Pass" to be green, "Fail" to be red, etc. It looks like I have to write a conditional…
-
Toggle Show/Hide Sheet Formatting on Reports within Conditional Sheet Formatting Modal
Wondering whether anyone else is running into this inconvenience. Issue: Often times, I have formatting on a sheet that I would rather not show on a report. There are a few workarounds but the added control would be handy. Idea: If there were a way to set a value/toggle within the conditional formatting modal when creating…
-
Conditional Format For "Task Bar" independent of "Entire Row"
My use case I have rules for various rows based on the Issue Type and I want a rule for the Task bar based on the status of the issue. For example, I want an Epic to show up with a Grey background, but I do not want the grey background to extend into the Gantt Chart but I want the Gant chart to show up as Green if the task…
-
Allow Gradient Conditional Formatting like Excel
Would love to have the ability to easily implement conditional formatting using a color gradient like you can do for excel. I know there are workarounds to achieve this, but would be helpful to have the functionality built in.