Importing Google Finance Data into Smartsheet?

edited 08/18/23 in Formulas and Functions

Hi all,

I'm attempting to pull Google Finance Data for monitoring stock price movements and creating charts for projected outcomes, etc. 

I'm not sure if Google Finance data is natively supported or not. I did attempt to import an existing Google Sheets spreadsheet with some formulas in it but receive an "#UNPARSEABLE" error for any formulas imported into Smartsheet.

Any tips or advice for achieving this would be greatly appreciated!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!