RAG Status and Trend updating automatically on a Smartsheet Dashboard - HELP!
do you know what is the best way to represent "RAG status" and "Trend" on Dashboard in Smartsheets? Will I have to create a report ? Am trying show RAG Status and Trend...where it automatically updated once status changes.....do you understand what I mean?
I have a datasheet that captures Weekly Status Report. Each project will state if they are either RED. AMBER or GREEN (in Smartsheet terms it would be Red/Yellow/Green/) and also state which way they are trending by selecting the arrows from the drop down list.
Answers
-
Hey,
You can use the metric widgets like you currently have and they will auto update as long as the widget is linked to the RAG and Trending cells you need the information from. You could also make a report and pull that report into your dashboard.
Ken Armstrong
Smartsheet Project Manager, GE Aerospace
Certified Smartsheet Administrator
Be Firm! Be Fair! Be Friendly! Be Honest!!!
-
You could also make a report and pull that report into your dashboard. ....how?
-
Hi @rakmis
Here's a free webinar on how to build a Report: SmartStart: Reporting
This other video also helps explain grouping and summary, if that's what you'd like to do: Redesigned Reports with Grouping and Summary Functions
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives