-
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,…
-
Multiple Logic Requirements in Forms
Is there a way within a Smartsheet Form, two have a field only show if two fields are equal to a certain value? i.e if field one equals x and field two equals y show field three.
-
Highlighting Past Due Items for Different Dates
I’m looking for a way to highlight when a date exceeds 5 business days without explicitly setting due dates. For example, if I enter a submission date as 2/3, how can I automatically highlight it as past due on 2/10? Any suggestions on how to track this in Smartsheet? Each line has a different request with different…
-
Merged: Multiple delete/disable for conditional formatting
This discussion has been merged.
-
Delete multiple conditional formatting rules simultaneously
Is there a way to delete multiple conditional formatting rules at once? I have over 100, and 40 different sheets to delete them on. Is there a better way than just clicking through and deleting one by one?
-
Can't delete column, can't find conditional formatting rule that's preventing it
There was one conditional formatting rule that referenced the column in question. I deleted that rule, but still can't delete the column. Would be nice if SS would identify the any associated rules—am I missing something?
-
Cannot get a column on a sheet to change column type
I have a sheet that when I go to edit column properties and change the column type to "Checkbox" it does not show a checkbox in the column. I can change it to a drop down or date field or any of the other column type options. but when I choose "Checkbox" I do not get checkboxes for that column. Can you help?
-
How to have multiple sheets show active items from a master sheet containing statuses?
I have a master sheet and want to feed multiple other sheets information from it. Master spreadsheet: is an employee roster, listing all employees and their status (active, inactive) Sheet 1: has a list of required training and training expiration dates Sheet 2: has a list of company assets assigned to each employee I want…