Copy Paste value if condition is true in Google Sheet

[Pabblymember11]

So I can not delete row from multiple sheets in a single spreadsheet? Any plans to add this functionality?

As of now, you cannot delete rows from multiple sheets from a Spreadsheet. But for this, you can make multiple Spreadsheets from which you have to delete the row.

Further, the Google API currently does not supports deleting rows from multiple sheets of a Spreadsheet.

 

[akgshanmuga]

Hi,

I was able to figure out the issue.

I was unable to delete the row in my "Form Response Sheet"

Whereas if i copied the data to a new spreadsheet and if the data lies in "Sheet1", i was able to perform the deleting the row option.

Is there any way wherein we can delete the row straightaway from the "Form Response Sheet"?

Thanks

 

[Pabblymember11]

Hey @akgshanmuga

Is there any way wherein we can delete the row straightaway from the "Form Response Sheet"?

As of now, you have to maintain the respective sheet at index 1 in the Spreadsheet in terms to delete the row from the sheets.