• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Google Sheet colon in column creating issue

Your Task History ID
IjU3NjMwNTZlMDYzMDA0MzI1MjZhNTUzZDUxM2I1MTZiNTQzMiI_3D_pc
Hi,
I keep getting this error:
Error Code400
Error MessageRequested writing within range [Data!A4958:C4958], but tried writing to column [D]
Error StatusINVALID_ARGUMENT

Following this thread: https://forum.pabbly.com/threads/google-spreadsheet-error-400.2001/ it seems that when a spreadsheet has a colon in a column it doesn't allow to update columns after it.
My column C contains the data and time (2024-02-19 10:04:04) and I am trying to update column D, but every time, it doesn't allow it for some reason.
There might be an issue on the backend of Pabbly that colon in columns disrupt the proper reading of the spreadsheet.

Thanks!
 

Supreme

Well-known member
Staff member
Hey @hugohamelcom

Can you please make a new connection once and then try again? Also, we cannot see the Update Row action step in your workflow concerning your desired task history ID.

1708343266062.png
 
Top