Sign in to join the conversation:
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?
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-
Derek,
Thank you for confirming it's not just an issue my team is having. Also appreciate the tip.
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
I am trying to find the right formula to use in the scenario if a cell in the row is yes, then it sums cells in the same row to create a total. threshold totalscore1 totalscore2 totalscore3 Final score yes 46 10 9 this would pull a total for the 3 total score cells in the row no 15 75 12 this cell would not total because…
I can't quite get the filter to align with my intent. I'm either pulling every status when I want to exclude "Complete" tasks or I can't get parent rows for my project schedule. I want the attached report to do the following for ease of presentation past due AND upcoming activities. Status is one of Not Started or In…
Hello! I'm currently creating formulas for a gift register to document the price ranges we have and how many are in each category. My categories are: £0 - £50 £50 - £100 £100 - £200 £200 + However, the formulas aren't pulling back all the data accurately because some of the cells include text too like 'less than £500' or…
