I created a script in one spreadsheet to copy data and then put it where I want on another sheet as a test but then learned about bound vs standalone script, so I realize I need standalone b/c I have different spreadsheets but what I have isn’t working. The first script runs from the custom menu and says successful, if I look at the execution log within the spreadsheet, I ran it from, the data is there. But when I run the script to retrieve the data in the other spreadsheet it says Script function not found. I’m trying to paste what I have but I’m getting an error it’s not formatted correctly once I add more than one script so I’m staring with what it will let me post.

function GatherData() { var standaloneScriptId = '1lCfVL0_o92-aHLppfW3W44AtXXOjmr3g3lOEGOepRhw8DQhmXvBkZxBd'; var standaloneScript = ScriptApp.openById(standaloneScriptId); standaloneScript.gatherShipmentDataV3(); // Replace 'yourFunctionName' with the actual function name }