Nine months after Google infused Gemini AI into Google Sheets, the AI system graduated from text and charts to taking on formulas. (Even those plopped into messy wedding planning spreadsheets, I found.)
Gemini’s chatbot appears on the right-hand side of Sheets. Now, when you ask how to manipulate data, Gemini will respond with suggested formulas and step-by-step instructions about how to make the formulas work — and why the formulas fail when they do. Errors will be followed up with a guide for how to correct the issue, Google says. If multiple formulas can do the same thing, Gemini will explain the options to the user.
Image: Google
Formulas, for me, often involve the pesky problem of figuring out which function I need to make it work with my data. (Is it COUNTIF or COUNTIFS, or maybe the wild card of COUNTUNIQUE?) So, I tried Gemini’s formula capability out for my wedding guest spreadsheet, a massive jumble of names, categories, email addresses, and checkboxes that my partner and I used to attempt to keep a handle on an ever-growing list of people with whom we wanted to celebrate our big day.
We got married in May, but this spreadsheet still gives me nightmares.
I expected that the math I would need to examine my guest list would be fairly straightforward, but testing Gemini’s explanation feature on this messy spreadsheet would be the test, for me, about whether it would help my daily life.
I first chose from Gemini’s suggested formulas that offered to “create a formula to count the number of guests who responded ‘Yes’ to the invitation.” Out popped a formula using the function COUNTIF in the column that I had labeled “RSVP.” (Typically, it would have taken me two or so Google searches to remember which function to use when tallying the number of items in a list that meet certain requirements.) I could insert the formula directly into my spreadsheet by clicking the button that appeared next to the formula.
I remember my wedding day as a joyous occasion full of the people that I loved most in the world — but Gemini’s answer told me that not a single person had said yes to my invite. That’s when I realized I had not actually tracked RSVPs in that column, despite the column header saying as much in the top row. Acceptances, I remembered, were tracked on the wedding website my partner and I used. I had quite literally forgotten about this website until Gemini told me that I had zero guests who RSVP’d yes to my wedding.
I tried again, this time on a more complex query: to calculate how many miles my guests traveled, collectively, to attend my wedding. (Given that my partner and I grew up on different coasts and our friends and family are spread out across the world, I knew the number would be high, but I wondered how high.) With all my guests’ addresses in the spreadsheet, and the address of the wedding venue on hand, I figured it would be possible, but just very annoying to do by hand.
Gemini also found my request annoying, responding, “I’m still learning and can’t directly calculate distances for you in the spreadsheet.”
But then the response provided me with a way forward: “However, I can guide you on how to do this manually using a custom script in Google Sheets or by providing a formula for straight-line distances.”
The first option required an adventure into the wild west of Application Programming Interfaces, or APIs, which is the software that two computer programs use to talk to each other. “Calculating driving distances requires using the Google Maps API, which isn’t natively supported by Google Sheets with a simple formula,” Gemini informed me.
The other option would be calculating “straight-line (as-the-crow-flies) distance, which is less accurate for road travel but simpler to implement” using a formula called the Haversine formula. I needed only the latitudes and longitudes, which Gemini apparently would not do for me. I found one set of coordinates to try it out.
I had to ask for the Haversine formula, and the first response was in mathematical script, which was not going to do it for me. Then I asked for the Sheets formula that calculates the Haversine formula and got:
=6371 * ACOS(COS(RADIANS(90 – A2)) * COS(RADIANS(90 – E2)) + SIN(RADIANS(90 – A2)) * SIN(RADIANS(90 – E2)) * COS(RADIANS(B2 – F2)))
Gemini’s response included a brief description of the “6371” number, which is the Earth’s radius in kilometers. For miles, I could use 3959. Gemini got an error because my latitude and longitude cells were in a different column.
Once I subbed in the cells for my latitudes and longitudes and switched to miles (because, ya know, America), the formula spat out a distance that another calculator website confirmed.
Ultimately, I did not want to find the coordinates for each guest address, so my enthusiasm for this quest quickly dissipated. But I did feel confident that I could with help from Gemini.
0 Comments
Follow topics and authors from this story to see more like this in your personalized homepage feed and to receive email updates.
Source link
#Gemini #explains #Sheets #formula #failed
![Kevin Feige Has Finally Admitted ‘Blade’ Probably Isn’t Happening
“There’s only been one Blade. There’s only ever gonna be one Blade.” When Wesley Snipes spoke those lines in 2024’s Deadpool & Wolverine, audiences cackled. Sure, Deadpool and the characters around him love to make self-referential jokes, but something about Snipes—playing Blade for the first time since 2004’s Blade: Trinity—delivering the joke hit extra hard. Comic-book movie lovers know, of course, that Marvel announced a Blade reboot starring Mahershala Ali all the way back in 2019. It’s had a stop-and-start progression since then and slowly became a bit of a punchline, with many fans coming to believe it would never actually happen. It’s not unheard of in Hollywood that a movie gets announced, then never actually goes into production. But it is unusual when a high-profile Marvel project starring a two-time Oscar winner that was trumpeted from the Hall H stage at San Diego Comic-Con gets quietly shoved to the bottom of the TBD list.
However, Marvel hadn’t made any statement putting Blade to rest until very recently, when Happy Sad Confused podcast host Josh Horowitz came right out and asked Marvel head Kevin Feige for an update on the status of Blade. Horowitz shared the clip in an Instagram reel you can watch here, but this is what they said:
“How much time in therapy have you spent talking about Blade?” Horowitz joked to Feige. “This poor project. We just need to get this done, Kevin … We all want it. Mahershala wants it. How are you feeling at this moment?” Feige replied, “I’m feeling very excited that we got Wesley back for a time in Deadpool & Wolverine and like a gigantic loser and a failure that we didn’t get off the ground with Mahershala.” So he doesn’t say there will never, ever be a new Blade film, no matter what Deadpool & Wolverine would have us believe. But it sure sounds like the Mahershala Ali Blade movie is no longer in play.
Horowitz also asked if there’s a chance Secret Wars could be two films (no), if Doomsday is sticking to its release date (yes), and what the MCU will look like after Secret Wars arrives in late 2027. “I look to the comics as I always do in terms of our storytelling,” Feige said, after noting he doesn’t consider Secret Wars to be a reboot. “And after both the Secret Wars, but particularly the [Jonathan] Hickman Secret Wars from 10 years ago, there’s a nice road map to where we can go.” Horowitz also asked if any actors have signed on for X-Men characters that we don’t know about yet, and Feige said, with supreme vagueness, “Not necessarily.” Perhaps we’ll learn more about that when Marvel’s Hall H panel happens this weekend at San Diego Comic-Con. Marvel didn’t hold its traditional Saturday night panel in 2025, so Feige and company have some catching up to do. Want more io9 news? Check out when to expect the latest Marvel, Star Wars, and Star Trek releases, what’s next for the DC Universe on film and TV, and everything you need to know about the future of Doctor Who. #Kevin #Feige #Finally #Admitted #Blade #Isnt #HappeningBlade,Kevin Feige,Marvel](https://i2.wp.com/gizmodo.com/app/uploads/2026/07/Blade_DeadpoolWolverine-1280x853.jpg?ssl=1 "Kevin Feige Has Finally Admitted ‘Blade’ Probably Isn’t Happening
“There’s only been one Blade. There’s only ever gonna be one Blade.” When Wesley Snipes spoke those lines in 2024’s Deadpool & Wolverine, audiences cackled. Sure, Deadpool and the characters around him love to make self-referential jokes, but something about Snipes—playing Blade for the first time since 2004’s Blade: Trinity—delivering the joke hit extra hard. Comic-book movie lovers know, of course, that Marvel announced a Blade reboot starring Mahershala Ali all the way back in 2019. It’s had a stop-and-start progression since then and slowly became a bit of a punchline, with many fans coming to believe it would never actually happen. It’s not unheard of in Hollywood that a movie gets announced, then never actually goes into production. But it is unusual when a high-profile Marvel project starring a two-time Oscar winner that was trumpeted from the Hall H stage at San Diego Comic-Con gets quietly shoved to the bottom of the TBD list.
However, Marvel hadn’t made any statement putting Blade to rest until very recently, when Happy Sad Confused podcast host Josh Horowitz came right out and asked Marvel head Kevin Feige for an update on the status of Blade. Horowitz shared the clip in an Instagram reel you can watch here, but this is what they said:
“How much time in therapy have you spent talking about Blade?” Horowitz joked to Feige. “This poor project. We just need to get this done, Kevin … We all want it. Mahershala wants it. How are you feeling at this moment?” Feige replied, “I’m feeling very excited that we got Wesley back for a time in Deadpool & Wolverine and like a gigantic loser and a failure that we didn’t get off the ground with Mahershala.” So he doesn’t say there will never, ever be a new Blade film, no matter what Deadpool & Wolverine would have us believe. But it sure sounds like the Mahershala Ali Blade movie is no longer in play.
Horowitz also asked if there’s a chance Secret Wars could be two films (no), if Doomsday is sticking to its release date (yes), and what the MCU will look like after Secret Wars arrives in late 2027. “I look to the comics as I always do in terms of our storytelling,” Feige said, after noting he doesn’t consider Secret Wars to be a reboot. “And after both the Secret Wars, but particularly the [Jonathan] Hickman Secret Wars from 10 years ago, there’s a nice road map to where we can go.” Horowitz also asked if any actors have signed on for X-Men characters that we don’t know about yet, and Feige said, with supreme vagueness, “Not necessarily.” Perhaps we’ll learn more about that when Marvel’s Hall H panel happens this weekend at San Diego Comic-Con. Marvel didn’t hold its traditional Saturday night panel in 2025, so Feige and company have some catching up to do. Want more io9 news? Check out when to expect the latest Marvel, Star Wars, and Star Trek releases, what’s next for the DC Universe on film and TV, and everything you need to know about the future of Doctor Who. #Kevin #Feige #Finally #Admitted #Blade #Isnt #HappeningBlade,Kevin Feige,Marvel")
![Kevin Feige Has Finally Admitted ‘Blade’ Probably Isn’t Happening
“There’s only been one Blade. There’s only ever gonna be one Blade.” When Wesley Snipes spoke those lines in 2024’s Deadpool & Wolverine, audiences cackled. Sure, Deadpool and the characters around him love to make self-referential jokes, but something about Snipes—playing Blade for the first time since 2004’s Blade: Trinity—delivering the joke hit extra hard. Comic-book movie lovers know, of course, that Marvel announced a Blade reboot starring Mahershala Ali all the way back in 2019. It’s had a stop-and-start progression since then and slowly became a bit of a punchline, with many fans coming to believe it would never actually happen. It’s not unheard of in Hollywood that a movie gets announced, then never actually goes into production. But it is unusual when a high-profile Marvel project starring a two-time Oscar winner that was trumpeted from the Hall H stage at San Diego Comic-Con gets quietly shoved to the bottom of the TBD list.
However, Marvel hadn’t made any statement putting Blade to rest until very recently, when Happy Sad Confused podcast host Josh Horowitz came right out and asked Marvel head Kevin Feige for an update on the status of Blade. Horowitz shared the clip in an Instagram reel you can watch here, but this is what they said:
“How much time in therapy have you spent talking about Blade?” Horowitz joked to Feige. “This poor project. We just need to get this done, Kevin … We all want it. Mahershala wants it. How are you feeling at this moment?” Feige replied, “I’m feeling very excited that we got Wesley back for a time in Deadpool & Wolverine and like a gigantic loser and a failure that we didn’t get off the ground with Mahershala.” So he doesn’t say there will never, ever be a new Blade film, no matter what Deadpool & Wolverine would have us believe. But it sure sounds like the Mahershala Ali Blade movie is no longer in play.
Horowitz also asked if there’s a chance Secret Wars could be two films (no), if Doomsday is sticking to its release date (yes), and what the MCU will look like after Secret Wars arrives in late 2027. “I look to the comics as I always do in terms of our storytelling,” Feige said, after noting he doesn’t consider Secret Wars to be a reboot. “And after both the Secret Wars, but particularly the [Jonathan] Hickman Secret Wars from 10 years ago, there’s a nice road map to where we can go.” Horowitz also asked if any actors have signed on for X-Men characters that we don’t know about yet, and Feige said, with supreme vagueness, “Not necessarily.” Perhaps we’ll learn more about that when Marvel’s Hall H panel happens this weekend at San Diego Comic-Con. Marvel didn’t hold its traditional Saturday night panel in 2025, so Feige and company have some catching up to do. Want more io9 news? Check out when to expect the latest Marvel, Star Wars, and Star Trek releases, what’s next for the DC Universe on film and TV, and everything you need to know about the future of Doctor Who. #Kevin #Feige #Finally #Admitted #Blade #Isnt #HappeningBlade,Kevin Feige,Marvel](https://gizmodo.com/app/uploads/2026/07/Blade_DeadpoolWolverine-1280x853.jpg "Kevin Feige Has Finally Admitted ‘Blade’ Probably Isn’t Happening
“There’s only been one Blade. There’s only ever gonna be one Blade.” When Wesley Snipes spoke those lines in 2024’s Deadpool & Wolverine, audiences cackled. Sure, Deadpool and the characters around him love to make self-referential jokes, but something about Snipes—playing Blade for the first time since 2004’s Blade: Trinity—delivering the joke hit extra hard. Comic-book movie lovers know, of course, that Marvel announced a Blade reboot starring Mahershala Ali all the way back in 2019. It’s had a stop-and-start progression since then and slowly became a bit of a punchline, with many fans coming to believe it would never actually happen. It’s not unheard of in Hollywood that a movie gets announced, then never actually goes into production. But it is unusual when a high-profile Marvel project starring a two-time Oscar winner that was trumpeted from the Hall H stage at San Diego Comic-Con gets quietly shoved to the bottom of the TBD list.
However, Marvel hadn’t made any statement putting Blade to rest until very recently, when Happy Sad Confused podcast host Josh Horowitz came right out and asked Marvel head Kevin Feige for an update on the status of Blade. Horowitz shared the clip in an Instagram reel you can watch here, but this is what they said:
“How much time in therapy have you spent talking about Blade?” Horowitz joked to Feige. “This poor project. We just need to get this done, Kevin … We all want it. Mahershala wants it. How are you feeling at this moment?” Feige replied, “I’m feeling very excited that we got Wesley back for a time in Deadpool & Wolverine and like a gigantic loser and a failure that we didn’t get off the ground with Mahershala.” So he doesn’t say there will never, ever be a new Blade film, no matter what Deadpool & Wolverine would have us believe. But it sure sounds like the Mahershala Ali Blade movie is no longer in play.
Horowitz also asked if there’s a chance Secret Wars could be two films (no), if Doomsday is sticking to its release date (yes), and what the MCU will look like after Secret Wars arrives in late 2027. “I look to the comics as I always do in terms of our storytelling,” Feige said, after noting he doesn’t consider Secret Wars to be a reboot. “And after both the Secret Wars, but particularly the [Jonathan] Hickman Secret Wars from 10 years ago, there’s a nice road map to where we can go.” Horowitz also asked if any actors have signed on for X-Men characters that we don’t know about yet, and Feige said, with supreme vagueness, “Not necessarily.” Perhaps we’ll learn more about that when Marvel’s Hall H panel happens this weekend at San Diego Comic-Con. Marvel didn’t hold its traditional Saturday night panel in 2025, so Feige and company have some catching up to do. Want more io9 news? Check out when to expect the latest Marvel, Star Wars, and Star Trek releases, what’s next for the DC Universe on film and TV, and everything you need to know about the future of Doctor Who. #Kevin #Feige #Finally #Admitted #Blade #Isnt #HappeningBlade,Kevin Feige,Marvel")
Post Comment