Dashboard Last Updated Date

Jenn Moffett

I would like to display the last time the dashboard was updated. My approach was adding a date field in the summary data that automatically pulls the last saved date of the sheet. I don't think I can do a formula in the date field type. Any other suggestions?

Ray Lindstrom

Hi @Jenn Moffett,

One approach is as follows.

1. Create a helper column. Name it "Modified", and select "Modified Date" as the column type. You can optionally hide this column.
2. Create a Sheet Summary field. Name is "Last Updated", and select "Date" as the column type.
3. Type the following formula into the "Last Updated" Sheet Summary field: =MAX(Modified:Modified)

Hope that helps! I just tested it before recommending, and it worked like a charm! :)

BRgds,

-Ray

Ray Lindstrom

Hi @Jenn Moffett,

One approach is as follows.

1. Create a helper column. Name it "Modified", and select "Modified Date" as the column type. You can optionally hide this column.
2. Create a Sheet Summary field. Name is "Last Updated", and select "Date" as the column type.
3. Type the following formula into the "Last Updated" Sheet Summary field: =MAX(Modified:Modified)

Hope that helps! I just tested it before recommending, and it worked like a charm! :)

BRgds,

-Ray

Jenn Moffett

That worked great for my first step. I have a follow up @Ray Lindstrom if you don't mind. I have a second dashboard, that publishes only a certain type of data from the list. So if This check box is checked true, produce max date modified out of those lines.

=IF([column]:[column]1,MAX(Modified:Modified),0) didn't work. getting #unparseable.

Ray Lindstrom

Hi @Jenn Moffett,

Glad that worked for you. I'm not quite following on your second request.

Jenn Moffett

I have one sheet that contains all of the information, but 2 dashboards come out of that sheet. The formula worked well for the 1st dashboard since it's all the information. The second dashboard is only part of the sheet's information. So if a specific column has a check box that is true, then I want to get the max dates out of those true lines. If the check box is false, skip it. Does that explain the issue?

Ray Lindstrom

1. Create a Sheet Summary field. Name it as you wish, and select "Date" as the column type.
2. Type the following formula into the field: =MAX(COLLECT(Modified:Modified, [Checkbox Column]:[Checkbox Column], true))
3. Replace the [Checkbox Column]:[Checkbox Column] part of the formula with your own checkbox column name.

Ensure your Sheet Summary field is a Date type column, or else you will get an error "#INVALID COLUMN VALUE".

Best of luck!

-Ray

Jenn Moffett

amazing! thank you!!

Peggy Parchert

@Ray Lindstrom

Is there a way to pull in the date & time from the Modified Date column? I'm looking to add an updated last metric to a couple dashboards but I need both the date & time the data sheets were last updated.

Any assistance would be appreciated.

Thanks, Peggy

Ray Lindstrom

@Peggy Parchert,

You could use a Sheet Summary field for this, and here is the formula to capture the latest date:

=MAX(Modified:Modified)

The column type for the Modified column is "Modified Date".

The Summary Field type is "Date".

I would also recommend locking the Sheet Summary field.

All the best,
-Ray

Peggy Parchert

@Ray Lindstrom

Thank you for the response. I created a Sheet Summary field for this as suggested. However, my problem is I'm looking for both the date and the time the sheet was last updated.

I tried to accomplish this with helper columns pulling out the Date and Time from the Modified column (system column) but where I'm lost is how to pull out the max (latest) date and time. The formulas I used to extract the Date and Time from the Modified column are below:

Date (date column property): =MAX(Modified:Modified)

Time Extract (text/number column property): =RIGHT(Modified@row, LEN(Modified@row) - FIND(" ", Modified@row))

I'm believe I will need more helper column(s) to assist with determining the latest (max) modified date & time but I'm at a loss on how to accomplish that.

Any assistance would be appreciated.

Thanks, Peggy