-
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…
-
Merged: Conditional Formatting on sheet level & row
This discussion has been merged.
-
Merged: Conditional Formatting for Single Cell
This discussion has been merged.
-
Changing Status Dot Color Based On Deadline Column
Hi, I've tried looking up other questions to answer this and got as far as this formula [=IF(Deadline@row <= TODAY(+14), "Green", IF(Deadline@row <= TODAY(+7), "Yellow", IF(Deadline@row >= TODAY(0), "Red", "")))], but it's not providing the proper results. I have a Deadline column and a Status column (which is the RGY…
-
How to use Conditional Formatting for duplicate values in a Column
I have a simple Smartsheet for re-ordering. The user scans the UPC of the item they need reordered. I'd like to setup a conditional format to highlight a cell if the UPC that is being added is already in the sheet. I can do this in Excel, having a hard time figuring it out in Smartsheet.
-
How to use the condition in request automation?
I am very new to Smartsheet and needing a bit of help. I am trying to set up a request update automation for individual fields as needed. For example I have approximately 32 fields that are autogenerated from a form. I am then trying to send an automation update request for fields that have a text associated in them,…
-
Logic Condition Formula (color symbol) is not working
I have been using a condition/logic formula on my sheets for 4 months. Today when I logged in, the formulas are not working correctly. Has anyone else experienced this issue? This has affected multiple sheets with same/similar formula. =IF([Next Action]@row = "Actively Monitoring", "Yellow", IF([Next Action]@row =…