Report Out

Pestomania · 07/17/24

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.

Andrée Starå · 07/29/24

https://community.smartsheet.com/discussion/127993/report-out

Hi,

I hope you're well and safe!

Unfortunately, as far as I know, it's not possible now, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

Here's a possible workaround or workarounds

- Use symbols to indicate the level
- Use emojis to indicate level
- Use reports to show the data with the conditional formatting

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Pestomania · 07/29/24

https://community.smartsheet.com/discussion/comment/446664#Comment_446664

Hi there! I tried that and while it helped in some cases, not all. I think I found a workaround that is not exactly like this but:

Essentially I created cells specific to the type and level in each of the columns. By doing so, it auto resizes the cells as needed (but I use a helper column that keeps everything aligned). When it brings them into the table, it creates a join of all of them together. I then had the issue of dealing with the bullet points not working properly, so I played with that to get the following formula. After all of that, the table may not look exactly like they are used to, but not far off.

=IF(JOIN(COLLECT({Risk Name}, {Risk Type}, LEFT([Strategic Risks]$1, LEN([Strategic Risks]$1) - 6), {Risk Climate}, $[Risk Climate]@row, {Archive}, false), ",") <> "", UNICHAR(10625) + " " + JOIN(COLLECT({Risk Name}, {Risk Type}, LEFT([Strategic Risks]$1, LEN([Strategic Risks]$1) - 6), {Risk Climate}, $[Risk Climate]@row, {Archive}, false), CHAR(10) + UNICHAR(10625) + "  "), "")

Andrée Starå · 07/29/24

https://community.smartsheet.com/discussion/comment/446669#Comment_446669

Excellent!

Nicely done!

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Report Out

Answers

Categories