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
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
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
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 303 Events
- 34 Webinars
- 7.3K Forum Archives