Quote of the Day on Dashboard
![Coby.C](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
Hi,
I am setting up our company landing Dashboard and am curious if there is a way to embed a quote of the day generator that posts a new quote to the dashboard everyday? Wondering if anyone has done this or done something similar.
Best Answer
-
Hi @Coby.C
I created this demo for fun. You need source data for the daily quote. Since I have only 20 quotes, I cycle through them using this formula:
=IF(INT(DAY(TODAY(1)) * 20 / 31) = [Row ID]@row, 1)
To display it on the dashboard, I used the metrics widget to make it look better. Here's the formula I used:
=JOIN(COLLECT({Quote}, {Quote of the Day}, 1))
Doesn't the quote in the image capture the spirit of our community?
Answers
-
It would take a fair bit of advance work - you'd need to assemble the list of quotes on a sheet. In another column, you could list the date said quote would be posted, and use use an INDEX/MATCH with TODAY() to pull one quote to the Summary and then use a KPI widget on your dashboard. You could alternately use a report to filter to the current date, and surface the report.
I personally haven't used a dashboard to surface info like a quote of the day like this, but the structure to do something like this appears fairly straightforward.
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
-
Hi @Coby.C
I created this demo for fun. You need source data for the daily quote. Since I have only 20 quotes, I cycle through them using this formula:
=IF(INT(DAY(TODAY(1)) * 20 / 31) = [Row ID]@row, 1)
To display it on the dashboard, I used the metrics widget to make it look better. Here's the formula I used:
=JOIN(COLLECT({Quote}, {Quote of the Day}, 1))
Doesn't the quote in the image capture the spirit of our community?
-
Thank you @jmyzk_cloudsmart_jp - just to clarify, the JOIN function goes in the QOTD Metric sheet that the Metric on the Dashboard pulls from - essentially that cell in the QOTD metric sheet updates daily based on what it is referencing from the QOTD Data sheet…? Do I understand correctly?
Thanks so much for the quick response. Your quote of the day absolutely reflects this community!
-
Hi @Coby.C
Yes, you've understood it correctly. The JOIN function should be placed in the QOTD Metric sheet, which the Metric widget on the Dashboard will reference. This way, the cell in the QOTD Metric sheet updates daily based on the data from the QOTD Data sheet.
Here's a step-by-step breakdown:
- QOTD Data Sheet: Contains your list of quotes and the corresponding dates they should be displayed.
- QOTD Metric Sheet: Uses the JOIN function to pull the quote for the current day.
- Dashboard: A Metric widget displays the quote by referencing the updated cell from the QOTD Metric sheet.
This method ensures that the quote of the day on your Dashboard updates automatically based on the current date.
Glad to hear the quote resonates with our community!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives