-
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 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…
-
Conditional Formatting in Edit Mode
When using the "edit" (form) function on a row it would be helpful to have the conditional formatting show within the edit mode, so folks using the edit-form function can see the conditional formatting as it does not show up, or have a way to add "text" within the conditional formatting setup. For example - if I am using…
-
How to create either a conditional formatting and/or use IF(AND) Formula for Attendance Tracker?
So I'm trying to create a formula or create conditional formatting for attendance. Every 1 Unexcused Absence within 45 days is 1 Occurrence that must be documented with the employee. Every 2 late arrivals/ tardies within 30 days count as 1 Occurrence that must be documented with the employee. So if my employee was…
-
How do I use predecessors to ensure a portion of rows are complete before being able to go to the ne
I am wanting to use this format for pre-con to ensure nothing is missed or overlooked. I want to mitigate mistakes from our project managers to prevent project issues by not allowing them to move to the next section until the section they are working on is complete. We also want to use conditional formatting to have the…
-
FORMULA: Conditionally Format Cells with Errors
This is unlikely possible with Smartsheet but I'd LOVE to be proven wrong :) I'm trying to Highlight Cells in the row that have errors. There might be one to twenty columns in that row with errors at any given time. Reason for it: One broken formula (or cell with bad data) can break several other formulas in that row. And…