Conditional formatting has disappeared!

paulen

Very strange! The conditional formatting of one of my spreadsheets just disappeared. I open the configurator and it is empty. Some settings are being applied but most are gone!

I am the only one allowed to change and nothing has changed. It happened overnight.

Rick Carlisle

This has happened to our account too! Empty condition formatting interface where there used to be several conditions.

Big issue!

Sean Morgan

Hello @paulen & @Rick Carlisle ,

We recently discovered an issue with Conditional Formatting where it removed the rules from Sheets.

If this is still occuring, please reach out to our Smartsheet Support Team, stating the affected Sheets, and they should be able to troubleshoot from there: https://www.smartsheet.com/contact

Kindest Regards

Sean

Josh Reed

This happens to me too but I usually notice it upon setup of a new sheet. The connection I've found is that if the conditional formatting does not apply to anything currently on the sheet, it is at risk of falling off. I recently set up a bunch of formatting before the entire data set was loaded in and it only save the formatting that could be applied to what was currently loaded.

What I end up having to do often is keep placeholder rows that keep all conditional formatting valid. My concern is when there is real data in sheets, perhaps at some point one rule is no longer active for a time-then it becomes active again but has disappeared in the interim.

I would like to say this issue was resolved but this happened to me literally two days ago. Several of my conditions disappeared as I was creating them. Saved the sheet, and when it auto-refreshed, they were gone.