Key matrix in dasboard doesn't display time.

Indra Kamphof

Hi all,

I am trying to show the date and time that the information from a sheet was updated in a dashboard. (I pull this from the automatically populated modification option in the sheet)

I use the Key matrix widget to display this.

Unfortunatly is doesn't pull the time but just the date.

we want to demonstrate how the coverage is on parts of the business per employee group. In order to ensure people are looking at relatively new data time is essential for me.

Can you help?

Thanks

Andrée Starå

Hi Indra,

If you add +”” to the end of the formula, it will show the time.

Did that work?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi Indra,

If you add +”” to the end of the formula, it will show the time.

Did that work?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Indra Kamphof

Hi, @Andrée Starå.

Great.

What I did was adding a column next to column that displays the auto-number/system date and added in this column next to it =column number +""

which now shows the time also on the dashboard.

It is weird that it doesn't do it immediatly with the auto-number/system even though it displays the time.

However it's fixed now.

Andrée Starå

@Indra Kamphof

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!