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
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives