Welcome!

Conditional Formatting Disappears When I Begin to Work in a Sheet

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

Average duration formula
I'm trying to get a formula for a sheet summary value to calculate average duration of rows where Risk Type = "EDAM Risk" and Status = "Resolved - Mitigated" or "Resolved - Decision." Assuming: Duration is in a column named Duration Risk Type is in a column named Type Status is in a column named Status I've been using the…
IF(AND formula
Hi, I am using this formula =IF([Warranty Status]@row = "Warranty Expired", IF(AND([Asset Status]@row = "In-Stock), "Out Of Warranty","")) Its says the formula is unparseable. I can't figure out the issue with the formula. Help is appreciated.
Formula error - Incorrect argument set
I am trying to write a cross sheet formula and keep getting the incorrect argument set error. The formula I wrote is: =SUMIFS({Total Poles}, {Vendor}, "ALLO", {Date}, >=TODAY(-30)) My formula is stating that I sound sum the amount of poles where the vendor column is Allo and where the date column lists dates within the…