Clear background / highlighting colors

Claude Younger

I added the "Modified" column to a report that feeds my dashboard. Some of the dates are highlighted yellow and some aren't. I checked the source sheets and I don't see any yellow. There was in the past, but it has long been removed and does not show up on any other reports. 

How do I get rid of the yellow highlighting that is showing up on my report?

Thank you,

Claude

Andrée Starå

Hi Claude,

It sounds to me like you have Highlight changes activated in the report.

Was that the issue?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Andrée Starå

More info:

Debbie Sawyer

Another area to check is Conditional Formatting, the button for which is found immediately to the left of the Highlight tool that Andre has pointed out in the previous reply.

Hope you find where the yellow is coming from

Kind regards

Debbie

Claude Younger

Thank you for your reply! I do not have highlight changes turned on in the report or the underlying sheets. Also, I'm not using conditional formatting on any of my sheets. 

Claude

Claude Younger

Thank you for your reply! I do not have highlight changes turned on in the report or the underlying sheets. Also, I'm not using conditional formatting on any of my sheets. 

Claude

Andrée Starå

Happy to help!

Can you see the color in the sheet or only in the report?

Claude Younger

The color is on the report (and of course the dashboard) but nowhere on the sheets that I'm running the report against. I do have one hidden column that I unhide and checked but it does not have the color either. The sheets are all built from the same template, but the yellow is not consistent. It shows up on six and not on the other two. 

I thought the color might be indicating a certain age or length of time since the last modification, but the color or lack of color stays the same when I make modifications. 

Thanks again for your help!

Claude

Andrée Starå

That is strange!

If you haven’t already, I would recommend that you reach out to the Smartsheet Support Team. Smartsheet Support Team

Debbie Sawyer

Hi Claude - this is intruiging.

Would you be willing to come on a zoom call with me and show me the sheets and the offending colours?

With Zoom you can share you screen and I would like to see this happening to see if I can spot a reason for it.

my email address is debbie.sawyer@smarterbusinessprocesses.com if you are happy to let me try and help diagnose this!

Kind regards

Debbie