[et_pb_section fb_built=”1″ _builder_version=”4.20.2″ _module_preset=”default” custom_margin=”0px||||false|false” custom_padding=”20px||||false|false” global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row _builder_version=”4.20.2″ _module_preset=”default” width_tablet=”” width_phone=”90%” width_last_edited=”on|phone” custom_margin=”0px||||false|false” global_colors_info=”{}” width__hover_enabled=”on|desktop” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
ChatGPT<\/a> has taken the world by storm and has become the fastest-growing web platform of all time. Within two months, this AI-powered chatbot developed by OpenAI<\/a> reached 100 million users all over the world.<\/p>\n Hundreds of millions of users are using ChatGPT to write essays, translate texts, solve math problems and even write code.\u00a0<\/p>\n Since everybody is jumping on the ChatGPT bandwagon, we\u2019ve decided to test this artificial-intelligence tool to understand if it can help us manipulate data and create formulas in Google Sheets<\/a>.<\/p>\n Can ChatGPT help spreadsheet users create formulas effortlessly?<\/p>\n Read on and find out how ChatGPT can assist spreadsheet users with their daily tasks.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-good-is-chatgpt” _builder_version=”4.20.2″ _module_preset=”default” custom_margin=”50px||||false|false” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In order to answer this question, we decided to ask ChatGTP \u201chow good is ChatGTP at generating Google Sheet formulas?\u201d. Here’s the answer:<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/ChatGPT-1.png” title_text=”ChatGPT-1″ _builder_version=”4.20.2″ _module_preset=”default” width=”70%” width_tablet=”65%” width_phone=”65%” width_last_edited=”on|phone” module_alignment=”center” custom_margin=”||30px||false|false” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” text_font=”|300|||||||” text_text_color=”#071623″ background_color=”#F6F8F9″ width_tablet=”” width_phone=”100%” width_last_edited=”on|phone” custom_margin_tablet=”” custom_margin_phone=”|5px||5px|false|true” custom_margin_last_edited=”on|phone” custom_padding=”20px|20px|20px|20px|true|true” custom_padding_tablet=”20px|20px|20px|20px|true|true” custom_padding_phone=”|10px||10px|true|true” custom_padding_last_edited=”on|phone” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n ChatGPT can generate Google Sheet formulas to a certain extent, but its ability to generate accurate and complex formulas may be limited.<\/span><\/i><\/p>\n As a language model, ChatGPT has been trained on a large corpus of text, but it has not been specifically trained to generate Google Sheet formulas. Therefore, its ability to generate formulas will largely depend on the quality and quantity of formula-related data it has been exposed to.<\/span><\/i><\/p>\n That being said, ChatGPT may be able to generate simple formulas such as basic arithmetic operations, SUM, AVERAGE, MAX, MIN, and other common functions. However, it may struggle with more complex formulas that require advanced functions, nested formulas, or conditional statements.<\/span><\/i><\/p>\n In summary, while ChatGPT may be able to generate simple Google Sheet formulas, it may not be the best tool for generating complex or highly specialized formulas. It is always recommended to verify any formula generated by ChatGPT with a spreadsheet expert or reference materials to ensure its accuracy.<\/span><\/i><\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” text_font=”|300|||||||” text_text_color=”#3B4344″ background_color=”RGBA(255,255,255,0)” custom_padding=”0px|0px|0px|0px|true|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n It seems that ChatGPT can create simple formulas but it may struggle to generate more complex formulas. However, we’re not going to take ChatGPT’s word for it.<\/span><\/p>\n Let’s put ChatGPT to the test and find out how well it can generate formulas in Google Sheets.<\/span><\/p>\n [\/et_pb_text][et_pb_text module_id=”first-challenge” _builder_version=”4.20.2″ _module_preset=”default” custom_margin=”50px||||false|false” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Generate a formula that calculates the difference between a date in column B and today in days, unless column D is filled, in which case it should calculate the difference between the date in column B and the date in column D. Use it inside an ARRAYFORMULA().<\/i><\/p>\n Here’s ChatGPT’s answer:<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/ChatGPT-2.png” title_text=”ChatGPT-2″ _builder_version=”4.20.2″ _module_preset=”default” width=”70%” width_tablet=”65%” width_phone=”65%” width_last_edited=”on|phone” module_alignment=”center” custom_margin=”30px||30px||true|false” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” background_color=”#F6F8F9″ custom_margin=”0px|0px|0px|0px|true|true” custom_padding=”20px|20px|10px|20px|false|true” border_radii=”off|12px|12px||” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Here’s the formula that calculates the difference between a date in column B and today’s date in days, unless column D is filled, in which case it calculates the difference between the date in column B and the date in column D. The formula is enclosed in an ARRAYFORMULA to apply it to the entire column:<\/i><\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” text_font=”|300|||||||” text_text_color=”#F6F8F9″ text_font_size=”18px” background_color=”#838C93″ custom_margin=”0px||0px||true|false” custom_padding=”10px|20px|10px|20px|true|true” border_width_all=”8px” border_color_all=”#F6F8F9″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n =ArrayFormula(IF(D:D<>””,DATEDIF(D:D,B:B,”D”),DATEDIF(TODAY(),B:B,”D”)))<\/i><\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” background_color=”#F6F8F9″ custom_margin=”0px||20px|0px|false|false” custom_padding=”10px|20px|20px|20px|false|true” border_radii=”off||2px|12px|12px” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The formula starts with an IF statement that checks if column D is filled. If it is, the formula uses the DATEDIF function to calculate the difference in days between the dates in columns D and B. If column D is empty, the formula calculates the difference between today’s date and the date in column B using the DATEDIF function.<\/i><\/p>\n The DATEDIF function calculates the difference between two dates in days, months, or years. In this case, we use “D” as the third argument to calculate the difference in days.<\/i><\/p>\n The ArrayFormula function allows the formula to be applied to the entire column B, so it calculates the difference for each row in the column.<\/i><\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Although ChatGPT managed to generate a formula from the prompt, the result wasn’t correct. As you can see, when we apply the formula, it returns an error.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/ChatGPT-4.png” title_text=”ChatGPT-4″ _builder_version=”4.20.2″ _module_preset=”default” custom_margin=”||50px||false|false” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”second-challenge” _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Generate a formula that calculates the difference between a date in column B and today in days. Use it inside an ARRAYFORMULA().<\/i><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/ChatGPT-3.png” title_text=”ChatGPT-3″ align=”center” _builder_version=”4.20.2″ _module_preset=”default” width=”70%” width_tablet=”65%” width_phone=”65%” width_last_edited=”on|tablet” custom_margin=”30px||30px||true|false” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” background_color=”#F6F8F9″ width_tablet=”” width_phone=”” width_last_edited=”on|phone” custom_margin=”||0px||false|false” custom_padding=”20px|20px||20px|false|true” border_radii=”off|12px|12px||” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Here’s the formula that calculates the difference between a date in column B and today’s date in days. The formula is enclosed in an ARRAYFORMULA to apply it to the entire column:<\/i><\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” text_text_color=”#F6F8F9″ background_color=”#838C93″ custom_margin=”0px|0px|0px|0px|true|true” custom_padding=”10px|20px|10px|20px|true|true” border_width_all=”8px” border_color_all=”#F6F8F9″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n =ArrayFormula(DATEDIF(B:B,TODAY(),”D”))<\/i><\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” background_color=”#F6F8F9″ custom_margin=”||20px||false|false” custom_padding=”|20px|20px|20px|false|true” border_radii=”off|||12px|12px” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The DATEDIF<\/strong> function calculates the difference between two dates in days, months, or years. In this case, we use “D” as the third argument to calculate the difference in days between the dates in column B and today’s date.<\/i><\/p>\n The ArrayFormula<\/strong> function allows the formula to be applied to the entire column B, so it calculates the difference for each row in the column.<\/i><\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” background_color=”RGBA(255,255,255,0)” custom_padding=”|0px||0px|false|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Now ChatGPT has created the right formula to calculate the difference between a date in a column and today’s date.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/04\/ChatGPT-5.png” title_text=”ChatGPT-5″ _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”conclusion” _builder_version=”4.20.2″ _module_preset=”default” custom_margin=”50px||||false|false” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Apparently, ChatGPT’s answer to the question “how good is ChatGTP at generating Google Sheet formulas?\u201d has summed it all up in a few words.<\/p>\n In summary, while ChatGPT may be able to generate simple Google Sheet formulas, it may not be the best tool for generating complex or highly specialized formulas.<\/i><\/p>\n If you don’t know how to create simple formulas in Google Sheets, ChatGPT can come in handy. Not only does it generate basic formulas, but it also gives us a brief explanation of how it works.<\/p>\n However, if you need to create more advanced formulas, you may have to wait a little longer. Although ChatGPT has evolved very fast, it is still not ready to alleviate the workload of spreadsheet users who need to generate complex formulas in Google Sheets.<\/p>\n It’s hard to know what the future holds for artificial intelligence. Things are changing, and they are changing very fast. Microsoft has recently announced that it is bringing ChatGPT technology to Word, Excel and Outlook<\/a>.<\/p>\n At this pace, spreadsheet formulas may soon become a thing of the past.<\/p>\nHow good is ChatGPT at creating Google Sheet formulas?<\/h3>\n
First challenge: creating an array formula with an if function<\/h3>\n
Second challenge: using an array formula with sum<\/h3>\n
Conclusion<\/h3>\n