-
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…
-
Multiple IF / AND / OR Statements Help, Please.
This is such a great community and a wealth of knowledge for a new Smartsheet user like me. I have done several formulas, but this one has me scratching my head. I have a [Target Date] column, [% Complete] column, and status column that I would like to automate with Red, Yellow, Green, and Gray status balls. The [%…
-
Automated Reminder Status Linking
I am wondering if it is possible to link automated reminders to my status colors on my Gantt chart. For example, if an item is completed, it turns green; if it is due in 7 days, it turns yellow; and if it is due on the day or is overdue, it turns red. And if it is overdue, then it wont sent out the reminder.
-
Conditional Formatting Not able to select in list even though it's in a dropdown column
I have a column that is a dropdown column that I want to be able to select from a list in the conditional formatting tool. However the list view does not have all my choices even after I have saved my sheet and refreshed it. I know I could use the define custom criteria and do each one individually but that would take a…
-
Source Sheet Conditional Formatting on Dashboard Web Content Widget
Over the last few weeks, I have received notifications from users that the Conditional Formatting on a Source Sheet is not accurately reflecting on the Dashboard that our end-users are accessing. The Conditional Formatting on the Source sheet is reflecting as expected. However, the dynamic view is incorporated on our…
-
Why is the branching logic in my form not working?
I have logic set up in a dropdown field that says if this field contains X, show the Y field. My issue is that the Y field is showing regardless if X is selected from the dropdown or not. Anyone know why this is happening?
-
Conditional formatting doesn't work on Gantt chart
Hi, I set up the below conditional formatting. As you see it works for the row formatting but not for the task bars. It doesn't have any children rows. Any idea what might be going on? Thank you!
-
Conditional formatting: remove condition, task bar changes even for parent rows, "or" options
Conditional formatting could be improved with the below options: remove condition: once I have added a condition, I cannot remove it. It's possible to change/edit it but can't completely delete. "or" options for additional condition: in the above the additional condition can only be added with "AND" logic but in some cases…
-
Conditional Formatting / By User
Adding my thoughts here on Conditional Formatting. Not everyone likes to see "color coding"/conditional formatting on sheets. It would be a great feature to have Conditional Formatting settings by user just like filters. If I set it up only I can see it unless I check the box "Share Conditional Formatting".
-
Marking Dupes based on multiple columns
Hello everyone, long time watcher, first time caller, I've been search for an answer for a while on the forum but I can't seem to get it to work. I am trying to highlight duplicates entries based on more than 1 column. I did the helper column with the duplicate check, using the countifs formula but this gives me the…