I can copy and past info but it changes 20 or 30 times per day I need the Update to be automatic?
There isnt a direct connection. Is there a reason you wouldnt just keep and update the information directly in Smartsheet?
There are 20,000 lines of data in the Google sheet documet we are using to hold the data. Smart sheet only allows 5000 lines. I would like to link data for reporting so I can see it on my dash board. But the smart sheet needs to update automaticly. thus the reason for the live link. If we can have unlimited lines your commet would work.
Thanks Ed
