I am trying to set up a Calendly to Google Sheets Zap. My spreadsheet will only populate certain cells in the row from calendly and I want those cells that have no data being passed to leave my drop down boxes and / or formulas in place. At present when the Zap runs it is removing my dropdown / formulas and replacing them with a totally blank cell.
Is there a way to stop this happening so that the data from Calendly is populated where needed but the other cells are left alone?
Thank you very much for any help,