Icon sets, driven by formula column, are not showing correctly in reports.

Soeder1 ✭✭
edited 11/09/22 in Smartsheet Basics

I have set up two icon set columns in my sheet. For both columns, I'm using a (different) formula to drive which icon is displayed. Both columns work fine and display correctly in the sheet. However, when pulling these columns into a report, one of them is not displaying the icons correctly.

The column labeled "health" should display blue, green, yellow, or red circles depending on the column formula. It looks right in the sheet, but in the report, it's only showing the blue circles. For cells where other colors should be displayed, they are just empty.

Very strange.

Anyone else have this problem or know a solution?

Here are images of the report file (missing icons circled in yellow) and the sheet file (all icons display fine in the sheet file):