Linking Google Sheets with a Sheet - not updating
Hi - I have been spending the last few weeks developing my Standard Operating Procedures (SOPs) in Smartsheets. I have been having an issue getting my Google Sheets (G-sheet) to sync with the sheets that were formed when I imported the G-sheet. Specifically, when a line item is updated on G-sheets - it is not updated in the Smartsheet sheet. I have successfully shared a links to sheets and documents (via widgets) and they sync properly. The issue arises when I import a G-sheet to sheet. The reason I did this is that I have multiple dashboards and am trying to share certain lines from the G-Sheet to each dashboard. The only way I found to do this was to import the G-sheet and develop a new sheet. From there I was able to share specific lines to other sheets/dashboards. The issue is that when I update the original G-sheet the Smartsheet sheet and associated shared lines are not updating. I am assuming this is because I imported it as opposed to linking it - but I can't figure out how to share the individual lines to additional sheets from G-sheets otherwise.
I hope that makes sense 😀
I have multiple employees and we use G-Suite as well as Smartsheets.
Can someone explain to me what I am doing incorrectly and how to resolve it?