adding conditional formating in reports

Hilbert Kok

Hi,

I have created a report getting summary data out of multiple smartsheets , This report is then used in a dashboard. I would like to use colors to identify the different results out of the report. I can not find any functionality to do this. Can anybody tell me if this is possible and how to do it if possible?

for example, Completed = Blue, Not started = Yellow, In Progress = Green

Paul Newcome

Conditional formatting would need to be built into the source sheet(s).

Hilbert Kok

Hi Paul,

First thx for your response.

The data for the reportsheet is coming from the summary data tab in the sheets. I can not find any possibility to use conditional formatting in the summary tab. Also in the report sheet there is no possibility to use conditional formatting, Am I overseeing something?

Paul Newcome

I didn't realize the source data was coming from actual sheet summaries. Sorry about that.

There is no conditional formatting built into reports.