Conditional Formatting not applying consistently
I have a sheet with conditional formatting rules so that if there is a "0" in a cell the text will be gray and if there is a negative number it will be red. If I close the sheet and then open it again the conditional formatting does not show, but if I go into the setting and basically pretend to change the formatting it will save and show the colors. After I do that any time that criteria is met the formatting sticks, but as soon as I leave and come back it happens again.
There are underlying formulas to the data so I suppose that can be the issue, but I was just wondering if anyone else has experienced this issue. It is the first time I have seen it and we use conditional formatting often.
Comments
-
That is peculiar. I would report that to support. Let us know what you figure out.
-
Hi Sara,
It is a known bug and I've been advised that Smartsheet is working on a resolution.
-
Has this bug been fixed? I have half my sheet the conditional formatting is working and the bottom half it is not.
-
This is an older thread from 2018 and there have been multiple updates to Smartsheet since then, yes. Can you clarify what your specific scenario is, and post screen captures of your sheet and formatting rules? (Blocking out sensitive data)
Thanks!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
After awhile on the phone with support. We figured out that the new lines in the project did not have the formula in the Ancestor and Children rows. We have them hidden in the project. By unhiding them we figured it out. By dragging the formula down it worked correctly.
-
That's good to hear!
An alternative to dragging down formulas is to set them as a Column Formula (depending on the syntax). This way you can be confident it will update no matter where rows are added.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives