Report Out

Pestomania
Pestomania ✭✭✭✭✭
edited 07/18/24 in Smartsheet Basics

I have a table of data that I would like to kick out into different dashboard images.

Sheet 1: Risk Data

Sheet 2: Climate Assessment (below is what I want it to look like).

Sheet 2 Formula: UNICHAR(10625) + JOIN(COLLECT({Risk Name}, {Risk Type}, LEFT([Primary Column]$1, LEN([Primary Column]$1) - 6)), CHAR(10) + UNICHAR(10625) + " ")

Color is based on a conditional formatting of "Rating" cell. The rating cell is on "Risk Data" and the risk name is formatted on "Risk Data", but it will not pull over the formatting from that sheet. It needs to put the risks in order of High, Medium, Low.

I unfortunately cannot provide a screenshot of these sheets.

Answers