How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • Go back-and-forth until satisfied
    Rate the answer you receive.
Ask Ameen Khan Your Own Question
Ameen Khan
Ameen Khan,
Category: Programming
Satisfied Customers: 12063
Experience:  Senior IT Support Specialist at Brookfield Asset Management
101830517
Type Your Programming Question Here...
Ameen Khan is online now

I need help with coding a spreadsheet. I have an online

Customer Question

Hi. I need help with coding a spreadsheet. I have an online application form that people fill in. I am trying to use Zapier to connect to Google Sheets. I have the data coming through, but it is not perfect. Once the data is in Google Sheets, I need to divert the rows to different spreasheet tabs. I need the following help with all or parts of the following:
1) Help getting Zapier to create two rows in my google sheets. This will involve splitting.
2) Help getting my row data in google sheets "pushed" to another tab within the sheet via at drop down menu at the end of a row. I need 10 options in the drop down menu for 10 tabs. I have the code in the google sheet script to push to one tab already, but need the script code amended to allow a drop down menu for 10 tabs
3) I also need help creating a column with formulas built in to each cell within the column. I can create a formula in one column and then copy and paste it in to the next cell in the column (or drag it down) but this is creating problems when I have a long row with a lot of data and formulas. I need to be able to insert a row and have the formula retained in the row.
Submitted: 10 months ago.
Category: Programming
Expert:  Ameen Khan replied 10 months ago.

Hi! My name is Ameen and I'll be assisting you. Secure Remote Assistance is NOT REQUIRED (But Helpful)

I am sorry you are having this concern, I will do my best to help you today.

To answer your question -> See steps below:

You can perform the two rows in Zappier on Google sheets by following this article - https://zapier.com/apps/google-sheets/tutorials/how-to-add-columns-rows-google-sheets

https://zapier.com/app-directory/excel/integrations/google-sheets/11117/add-new-excel-rows-to-google-sheets

In regards ***** ***** 2nd question about getting google sheets pushed to another tab follow this article - https://zapier.com/learn/how-to/link-spreadsheet-data/

and

https://zapier.com/app-directory/google-sheets/integrations/google-sheets/536/send-data-from-one-google-sheets-spreadsheet-to-another-google-sheets-spreadsheet

-------------

Let me know if you have any follow up questions. I am here to help you.