• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

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!
 
P

Pabblymember11

Guest
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