nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Conditional Formatting Disappears When I Begin to Work in a Sheet

Katelin L.

When I am enter into a sheet with conditional formatting I can see it applied. But if I search for something, or begin to scroll, or click into a cell the formatting starts to disappear until it is all white again. When checked the formatting rules are still present. I checked and didnt see another issue like this occuring. Has this happened to anyone else? Is there a solution? Is it a Smartsheet issue that hasn't been published yet?

Find more posts tagged with

Sheets

functionality

Comments

DHopkins

Hello,

I am having the same issue. No issues yesterday, but it started this morning for my whole team. Possible some backend update that is causing a bug? A few things I have learned that may be helpful:

If you disable and enable the rules the formatting will hold. You can even work and save and nothing will break.

Once you refresh the page, the formatting rules break again.

-Derek-

Katelin L.

Derek,

Thank you for confirming it's not just an issue my team is having. Also appreciate the tip.

Marcela

Hello Community,

Thank you for bringing this to our attention!

Our team is currently investigating issues with Conditional Formatting and Filters. Please visit status.smartsheet.com to view updates on the issue or subscribe to the relevant alerts.

Best,

Marce

Sign in to join the conversation!

Quick Links

Trending discussions

Formula to create a list from another sheet column
Good morning all. I've been trying, unsuccessfully, to create a formula to pull (populate) all names listed in a column from another sheet. The closest I've been able to get is utilizing the formulas below but neither are what I need. Cell linking does not appear to be a good option due to the potential to add additional…
Counting occurrences of drop down menu selections
Hi all, I'm looking for a COUNT or COUNTIF formula to total drop-down menu selections within a given range of cells in a column range. The attached shows the DD menu with trusses selected. Our sheets are broken into calendar months, sometimes with over 100 entries for that month. Not every cell within that column has…
Automated Notifications
Please tell me WHY when I "test" run this automated notification it shows everything, and not just what my "triggers" are? Is it because it is a test and I can be certain it won't show up when the trigger occurs?