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'm looking to create a formula that will count the number of overdue tasks. This is based on the "assigned to", "status" and "due date". My current formula is =COUNTIFS({[Sheet Name]}, <TODAY(), {[Sheet Name]}, ="[Assigned To]"). However, this is pulling tasks that are due in the past, but are completed.
In the above image the green is the parent line, where some are calculating the child line %'s below, however in the lower half of the image it's not doing so. Any suggestions please? Thanks!
I have a sheet where I query 14 other sheets to collect all sorts of data (unique values from sheet into a column) and in another column I use an Index distinct collect to get all the unique value from those 14 columns, this is the 'Index' column. At some point a user will want to generate a certificate associted with the…
