Put two fields from a report on a dashboard, and just those two fields, no column headers

James Keuning

I have a dashboard that shows a bunch of information about upcoming publications. Things like who is contributing, submittal deadlines, approval deadlines, etc.

I have sheet with the publication date in it. I want this date to appear at the top of the dashboard. Literally something like:

Publication Date: 05/11/2021

Is there a trick to accomplish this? I am not using a text box because the date comes from a sheet. I can show it in a report. So currently it looks like this:

How can I make this more appealing?

Jen Lange

Hi @James Keuning. Yes, you can accomplish this display on the dashboard by adding a "Metric" widget that pulls from the cell on your sheet or your sheet summary.

Below is a compilation of multiple metrics from one sheet summary. You can add one or multiple.

1) Go into edit mode on your dashboard

2) Click on Add Widget

3) Select Metric

4) Click Add Data

5) Locate/Select your sheet

6) Select Grid data or Sheet Summary data

7) Select the cell or field

8) Adjust the format, name, title or no title, etc.

Let me know if this works for you.

-Jen