-
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…
-
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?
-
Ability to Change Column Type When Conditional Formatting Exists
I would like to be able to change column types without having to delete conditional formatting rules. Currently I have 20 columns that I want to change from Text/Number to Dropdown List. They each have 5 Conditional Formatting rules applied to them. I can't change the column types without deleting the rules first. I can…
-
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…
-
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…