In this tutorial, I will show you the differences between getValue and getDisplayValue in Google Apps Script.
I used a default project with a default spreadsheet document with my birthday 1976-03-07 into A1 cell and format text as year-month-day.
I add Apps Script API to my project.
On the spreadsheet, I used ToolsScript editor to create my Google apps script.
I get my project id and set it on my default script on the ResourcesCloud Platform project…
Let’s see the Google Apps script I used:

The run of this script will show a message alert into a Spreadsheet with this text:

You can clearly see the differences between the two functions.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.