Can I turn a table into a heat map?

Peter Eck

I have a table with two axes. The table is roughly 15x15, and each cell is an integer value. In Excel, I'd apply conditional formatting and easily turn this into a heat map. Can I do something similar in Smartsheet?

Thank you!

Andrée Starå

Ok.

Yes, you can.

We'd use the Conditional Formatting feature with conditions. See example below.

Make sense?

Andrée Starå

Hi Peter,

It’s not the same as Excel, but something like this can be created.

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Peter Eck

Yes, that would work I think, but I have a wide range of values, so I'd need a way to say something like 0-10 = red, 11-20 = yellow, and = green. Can I do something like that, and if so, how?

Thanks so much for you guidance!

Andrée Starå

Ok.

Yes, you can.

We'd use the Conditional Formatting feature with conditions. See example below.

Make sense?

Peter Eck

Yes, that helps quite a bit, thanks! Wish we didn't have to define it column by column, but still gets the job done.

Andrée Starå

Excellent!

Happy to help!