How would you do the date part if you have data with numbers? (1/1/2020) instead of with text? (Report pulls directly form Salesforce so dates are unchangeable.
Great question! If your data has dates in number format (like 1/1/2020), you can still work with them in your Google Sheets dashboard. Google Sheets should recognize the numbers as dates if they’re formatted correctly. If you need to manipulate these dates, you can use functions like DATE, TEXT, or DATEVALUE. For example, you can use: =TEXT(A1, "mm/dd/yyyy") to convert a numeric date to a text format. If you need to extract parts of the date, functions like YEAR, MONTH, and DAY can be handy too. :)
You can reference empty cells where the data will later reside and add some parts of a dashboard this way but you won't be able to test if everything works as expected without data. A far better option is to quickly generate some dummy data with sites like www.mockaroo.com/. Or ask ChatGPT to generate a dummy dataset meeting your specific criteria and give you a csv file to upload to Sheets.
Hi! How would you like to format it? You'll find plenty of options in the 'Format' menu, such as changing the currency symbol, number of decimals, different alignment within cell, etc
AND YOU TAUGHT ALL THIS TO PROMOTE YOUR APP?!! THAT'S CRAZY AND PERFECT
Sick tutorial, found it helpful. Great delivery from the instructor!
Thanks!
How would you do the date part if you have data with numbers? (1/1/2020) instead of with text? (Report pulls directly form Salesforce so dates are unchangeable.
Great question! If your data has dates in number format (like 1/1/2020), you can still work with them in your Google Sheets dashboard. Google Sheets should recognize the numbers as dates if they’re formatted correctly.
If you need to manipulate these dates, you can use functions like DATE, TEXT, or DATEVALUE. For example, you can use:
=TEXT(A1, "mm/dd/yyyy")
to convert a numeric date to a text format. If you need to extract parts of the date, functions like YEAR, MONTH, and DAY can be handy too. :)
Juste parfait! 👌🏼
Merci! :)
good stuff, thanks
No problem!
what if you don't have any data to pull into the dashboard yet? Is there a way to structure a dashboard without data?
You can reference empty cells where the data will later reside and add some parts of a dashboard this way but you won't be able to test if everything works as expected without data. A far better option is to quickly generate some dummy data with sites like www.mockaroo.com/. Or ask ChatGPT to generate a dummy dataset meeting your specific criteria and give you a csv file to upload to Sheets.
for the table chart, how can I display the amount for only 2 d.p?
Hi! You can use the "Custom number format" option from the Format -> Number menu to decide on the number of decimal places.
How do I format the Total Order column in the table?
Hi! How would you like to format it? You'll find plenty of options in the 'Format' menu, such as changing the currency symbol, number of decimals, different alignment within cell, etc
Super helpful!👍
Awesome to hear that, thanks!
Really helpful 😊
Glad you think this way, thanks!
Can we 2 slicer for 1 data
Hey! Definitely, add as many slicers as you need :)
Great video!
FYI the month column is missing
Month column is missing in the template in the description
This was so helpful!
Glad to hear that!
excellent tutorials. need more video
Thanks! Such comments inspire us to make more tutorials 🫶
U good
cheers
Last bit is not a secret tricks it is a ad. First time i am watching you and last time. Bye
Thanks for watching anyway!
oh no what will they ever do with out you!