-
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 =…
-
Conditional Formatting for a Modified By Column
I am trying to create an automation or formula to populate a cell. Here's the gist of what I am trying to accomplish: Only when a completed box in a column is checked → I want to populate another cell in that row with the Current User who checked the box. I would like this to populate automatically through the use of a…
-
Coloring
Is there any way to use Color Hex Codes to further customize the columns, rows, and/or text of our workspaces? If not, please add this in future updates.