-
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.
-
Template / Themes for Conditional Formatting
I would love to be able to be able to apply a conditional formatting template to any sheet I wished - much like a design theme in Office 365. And - if I change a rule, it would change it for all the sheets using that template. Can you imagine? How wonderful!
-
Can I create a drop down list which will remove one choice after it is picked?
Hello - I have a form that I use drop down choices for delivery times at my place of business. I would like to upgrade to the business version but need to make sure this will work for me before proceeding. Currently multiple delivery time choices can be taken but I only want to show the times available. For instance, we…