Can it be done? Creating a workflow with a form from a seperate spreadsheet.
I have setup a sales pipeline spreadsheet and a separate proposal tracking spreadsheet. I would like to create a automatic workflow in the sales pipeline sheet so that when "Proposal" or "Pitch" is selected as a status in the pipeline a automatic workflow takes place to present the form for the proposal tracking spreadsheet.
Is this possible to have two sheets working together in this fashion?