-
Conditional formatting legend
I would love to offer a legend for users to understand the conditional formatting for a given sheet. Not all users are able to see the rules and may not remember what the formats indicate. Adding a button or pop-up banner/tool tip would be a great improvement. I try to use the column description when I can, but the…
-
Remove all conditional formatting options
It would be nice to have the option to select all/some conditional formatting that need to be removed. Some sheets have many and even though they can be disabled, they need to be removed for structural changes.
-
Nested IF statement for multiple date range
Hello! I am currently attempting to write an all encompassing formula to read through different work windows. We are only able to work in certain areas of the city depending on the "work window". Depending on the work window, these dates have differing start and end dates. I can get one window to work properly, but the…
-
Help to avoid hundreds of conditional formatting
Hi all, I have a sheet with columns that list a particular service. My rows are site names and we're tracking the level of adoption for each service with the below list: FI (H) FI (NR-H) FI (NI) C-FI P NI V N/A I want to have each one colour coded like you would with conditional formatting but I have 28 columns and so if I…
-
Cell shading not saving when I change it
everytime I update the cell shading to match the rest of the sheet or change to just be white, the change does not save, even if I save myself, it just goes back to the same way. from the picture I am trying to change the purple to grey and the white under the grey to grey
-
Conditional Formatting Behaving Unexpectedly
Hi, I have not been able to figure out what to change to get the conditional formatting in the sheet, per the second rule, to dynamically change as time passes and/or the status changes. The red font is not changing back to black when the End Date becomes in the past, and/or the status column is changed to Complete. Thanks…
-
How can I visually group rows together using automation?
I am in the process of moving information from Google Sheets to Smartsheet. I would like to automatically apply formatting to a group of rows to indicate that they belong together. In Google Sheets, I would use borders to separate orders. This would indicate to my team and a group of items belonged to the same order…
-
Automation
Hi everyone, I need to delete duplicate rows in a sheet. How can I create an automation to delete one of the "n" duplicate rows? How can I create an automation that deletes a row completely under specific conditions? Also, is it possible to highlight duplicate rows with conditional formatting? Thank you!
-
How to add column that shows start/finish time in minutes?
I see you can list a task in minute increments, e.g. 15min. We are creating a cutover plan and need to list a start & finish TIME: e.g. 9:00, 10:00, etc. Does Smartsheet have this as an "intelligent" column or just a text/number one only? Would be extremely helpful, so that folks can time the work and also, if you add…
-
Symbols for Multiple Columns or Adding Conditional Formating
Hi, Is there a way smartsheet can make it easier to apply conditional fomulas on multiple rows that meet the "N" = red and "Y" = green, rather than having only a format that can let me select multiple columns to the same color when 1 column has a "N" and setting a new rule each time I want to have "N" be red in a different…