Is there a way to add charts or create real time dashboards.
Have you looked into the SmartSheet Labs? I have not tried this myself, but I will now that I have found about it.
https://smartsheetlabs.com/smartsheetcharts
Rob
Smartsheet charts are quite good. Once you have created them you can then share them to people within the organisation as read only. If you are familiar with HTML documents then they can be published using their iframe.
You can also insert there url into a row on a smartsheet so that people can click on it and go to the relevent chart.