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
Hello, I am trying to figure out a formula that will SUMIFS my first range says "Perfect Match 111" and my second range has a number in it. Example if "Perfect Match 111" is in my first range 3 times then I want it to sum the number that is in my second range. So below I would want 6 to come back to my sheet. I have tried…
I have a column that the time input is in 24 hour time, but my staff will use 0700 instead of 07:00. Can I create a formula that will change 0700 to 07:00?
I have a multi-contact column where I assign users to a task [Assigned To]. I have another column where one of the assigned users selects their contact once they have completed their portion of the task [Completed By]. I want an automation that sends a reminder/Update request to Assigned Users that have not Completed their…