I want to show only the latest weekly update in my dashboard.

I have a smartsheet used to send out weekly updates to key stakeholders.

I also have a dashboard for all interested to view the project status. I am wanting to update the dashboard with the latest update from the spreadsheet.

on the dash board I want the last entries for issues & incidents/ What was accomplished this week and what will be worked on next week to show like:

But I don't want to have to go in weekly and change the line on the report to show. Is there a way to always show the last populated line of the sheet?

Thank you

Michelle Phillips

Accumen

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Is the most recent update always on the last populated row of the sheet?

Michelle Phillips

Paul,

Yes it is always the last row of the sheet.

michelle

Paul Newcome

Ok. And how exactly are you currently pulling this data? Are you pulling it into another sheet or using Sheet Summary fields?

Michelle Phillips

right now I am pulling the data into the dashboard

using the metric widget

Paul Newcome

Ok. I would suggest creating a new Sheet Summary field for each column of data that you want to capture.

Then you would use something along the lines of the below to capture the most recent data for whichever column(s) you want to pull from:

=INDEX([Column Name]:[Column Name], COUNTIFS([Weekly request]:[Weekly Request], @cell <> ""))

Then set your metrics widget to point at the sheet summary field(s).

Michelle Phillips

Great I will try that! Thank you Paul😀

Paul Newcome

Happy to help. 👍️

Michelle Phillips

That worked like a charm, thank you again

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.