Thank you so much for putting this tool together and providing these helpful video tutorials - I have gone through nearly all of them. Can't believe you are providing all of that for free. Thank you!!
thanks so much, I just wanted to ask how to configurate to get a Sommary from a table who get an 3 options bar PAYED, AVAILABLE to be payed, in process. where we have to detele PAYED from the soomary
Nice walkthrough! I keep running into this error when trying to format large amounts of records at once? "Exceeded maximum execution time (line 0)." any help would be appreciated!
Hello! There are 2 workarounds that we recently integrated to the add on to circumvent this type of error: 1. you can select an Azure model to run your formulas. Azure models are faster than other available models. 2. If you use GPT-4, you can enable the "GPT-4 safe mode" in the sidebar to bypass the 30-second runtime limit (gptforwork.com/help/gpt-for-sheets/control-gpt-formulas/gpt4-safe-mode)
Thank you very much for this exciting feature. However =GPT_FORMAT(B2,"iso date") returns NAME error. What could be the reason. The =GPT_FORMAT dose not come with google help.
Hey I wondering is there a way gpt for sheets can extract data from massive table. For example if I have massive table with new and old orders of different suppliers and delivery methods will it be possible for gpt to sort and extract data of specific supplier, product, etc and create a new table of extracted data, placing columns in specific order?
Hi Andrej, we can try. Can you send me your table via the request form? docs.google.com/forms/u/2/d/e/1FAIpQLSeNW6ynH1YfmgytrbLq2tPJouuI0qCQ_azg_W3eIPXxSzFIJw/viewform
is there a way to have gpt populate cells on a spreadsheet with hours of operation for various restaurants using a sloppy input such as "Closed Mon; 11a-930p Tu-Fri; 12p-930p Sat-Sun" It does not seem to be working with examples
Hello! We would be happy to help you with your use case but could you please explain a bit more what you mean by "cleaning up" open hours for restaurants? You can also detail your use case and share your spreadsheet by contacting our team here: support.gptforwork.com/hc/en-us/requests/new
I have a sheet with company, location, email and other columns. What I would like to do is extract data from selected columns as is and format them in specific ways such as company, location, and email each in a new line and as a numbered list
Hello! We would be happy to help you with your use case. Please contact the support to give more details about what you want to do: support.gptforwork.com/hc/en-us/requests/new
That company name cleanup saves hours of time per week alone. Dude, you rock!
Thanks !
Thank you so much for putting this tool together and providing these helpful video tutorials - I have gone through nearly all of them. Can't believe you are providing all of that for free. Thank you!!
Glad it was helpful!
Thanks for your tips.
you're welcome!
Thank you and have a nice day.
You too!
thanks so much, I just wanted to ask how to configurate to get a Sommary from a table who get an 3 options bar PAYED, AVAILABLE to be payed, in process. where we have to detele PAYED from the soomary
sorry I didn't understand your question
Nice walkthrough! I keep running into this error when trying to format large amounts of records at once? "Exceeded maximum execution time (line 0)." any help would be appreciated!
Hello! There are 2 workarounds that we recently integrated to the add on to circumvent this type of error:
1. you can select an Azure model to run your formulas. Azure models are faster than other available models.
2. If you use GPT-4, you can enable the "GPT-4 safe mode" in the sidebar to bypass the 30-second runtime limit (gptforwork.com/help/gpt-for-sheets/control-gpt-formulas/gpt4-safe-mode)
Thank you very much for this exciting feature. However =GPT_FORMAT(B2,"iso date") returns NAME error. What could be the reason. The =GPT_FORMAT dose not come with google help.
Hello! Please make sure you opened the sidebar within the document you're working on to enable the GPT functions.
Hey I wondering is there a way gpt for sheets can extract data from massive table. For example if I have massive table with new and old orders of different suppliers and delivery methods will it be possible for gpt to sort and extract data of specific supplier, product, etc and create a new table of extracted data, placing columns in specific order?
Hi Andrej, we can try. Can you send me your table via the request form? docs.google.com/forms/u/2/d/e/1FAIpQLSeNW6ynH1YfmgytrbLq2tPJouuI0qCQ_azg_W3eIPXxSzFIJw/viewform
is there a way to have gpt populate cells on a spreadsheet with hours of operation for various restaurants using a sloppy input such as "Closed Mon; 11a-930p Tu-Fri; 12p-930p Sat-Sun" It does not seem to be working with examples
Hello! We would be happy to help you with your use case but could you please explain a bit more what you mean by "cleaning up" open hours for restaurants? You can also detail your use case and share your spreadsheet by contacting our team here: support.gptforwork.com/hc/en-us/requests/new
I have a sheet with company, location, email and other columns. What I would like to do is extract data from selected columns as is and format them in specific ways such as company, location, and email each in a new line and as a numbered list
Hello! We would love to hear more about your use case to help you. Please contact our support team: support.gptforwork.com/hc/en-us/requests/new
hello, the format I am working with is "Mon Jul 24th, 2023", how can i fix it ?
Hello! We would be happy to help you with your use case. Please contact the support to give more details about what you want to do: support.gptforwork.com/hc/en-us/requests/new
👍👍👍👍👍
🙏