Report Out
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
-
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!SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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) + " "), "")
-
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!SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives