-
Conditional Formatting Combined with Dropdowns and Dates
Hello! I have a user tracking the progression of course development and is asking if there is a way to do some formatting on his sheet. The columns shown are set up as dropdowns (there are 8 total columns on this sheet). In the yellow row, in the cells where I've drawn a box, he is going to place due dates. Is it possible…
-
Sheet - Format Cell Border
The ability to format cell borders with line style and color.
-
Conditional Formatting based on availability of Attachment in a Smartsheet row
Hi Team Can we have a Conditional Formatting option based on the availability of Attachment in a Smartsheet row? For example: If a row has an attachment, then the row / or a particular field can be green; whereas if attachment is missing / pending, then it can be red.
-
conditional formatting for Duplicate Values
Excel have Conditional formatting option for highlight the duplicate values. Does this currently exist as an option for Smartsheets or could this be added?
-
Merged: 08075826: how to highlight duplicate values
This discussion has been merged.
-
How can I add a reference sheet to this formula - I have build another sheet that I want to add up
-
Smartsheet Color Matrix Names and Hex Codes + Programmatic Conditional Formatting
Howdy Smartsheet Community :) During a recent exercise to make Conditional Formatting programmatic, I indexed the color names and hex codes of the 8 x 5 Smartsheet color matrix. Wanted to share the results with everyone here, in case you have a need to extend these colors through non-Smartsheet collateral:…
-
Only Part of my formula is not working and I can't figure out why
I created the formula below and it is working for the section that says "Validations - Issue Validations" and "Validations - Regulatory Issue" part and I can't figure out why =IF([Risk Activity]@row = "Control Testing", IF([Actual Cycle Time]@row <= 75, "Green", IF([Actual Cycle Time]@row <= 90, "Yellow", "Red")), IF([Risk…
-
Is there a way to create 2 Reports from one Sheet with different formatting?
I am looking to create 2 Reports from one Sheet that contains employee time off requests. The Sheet contains 13 columns, but for simplicity, the relevant fields are as follows: Employee Name Division Start Date End Date PTO Used (# of hours) Approved? I would like to have one report for the managers to show Name, Division,…
-
Conditional Formatting - multiple columns
Hi All, Hope you are all safe. Is it possible to apply conditional formatting to multiple columns (same condition). I have data in 10 columns. I want to highlight cells where the value is not equal to 0. Currently I have to apply conditional formatting to each column separately (cloning the rule). Is there a faster way?…