-
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…
-
Conditional Formatting for Duplicates
Adding the ability to do conditional formatting by column, similar to how I would flag a column for duplicates in Microsoft Excel.
-
Conditional Formating on Workflow Emails
As of right now, there is no way for conditional formatting to show on emails that are generated through workflow. I suggest implementing a method to allow this, for example, I have conditional formatting that highlights fields when a specific criterion is met, but when I send that email out via workflow that…
-
Merged: Remove all Workflows options
This discussion has been merged.
-
Dynamic View - Conditional Formatting in Blank Cells
Dynamic View seems stumped by blank cells and doesn't properly apply conditional formatting. In the screenshot below, each of the white cells should have a color. As a workaround, we colored the entire column in the source sheet, which seemed to work initially. But then we realized that conditional formatting to change the…