Sign in to join the conversation:
I am trying to display a date in a metric on a dashboard, all the sheets have the date displaying DD/MMM/YYYY but the metric displays DD/MM/YY. How do I get the metric to display the date in the format that I desire?
Hi,
Currently the functionality of the Metric widget will display dates based on your personal regional settings, versus the date format you set up in the sheet. Please submit an Enhancement Request when you have a moment!
As an alternative, you may want to use a Title or Rich Text widget to type in the date. If there are multiple cells you were looking to display along with the date cells, another option would be to create a report for those specific details and then display that in your dashboard with a Report widget.
Thanks,
Genevieve
Hello, I have a destination sheet that is cell linked to a source sheet. The source sheet is constantly being updated (adding information, deleting information) but the destination sheet does not reflect those updates. Is there any work around this issue? Any way that the destination sheet reflects the updates real time? I…
Hi Can you utilize forms to make data entry easier into a row that already exists?. For instance, if I have pre-populated a sheet with 100 rows/items can I use a form to update certain columns in these rows…to make columns with multiple lines of text easier to enter? Many thanks Matt
i got this error while working , when i close it it pops up again, i even restarted the app but no use. this happened last week to but it stoppedthe next day. can summon help . Update : it now stopped, after restarting it again and popping up again it stopped.What is triggering this error .