23 comments

[ 2.5 ms ] story [ 57.3 ms ] thread
Has anyone tried asking open.ai for spreadsheet formulas?
Yes ASK_OPENAI(“write a spreadsheet formula that averages values in column A if column C equals Facebook”)

That worked for me!

I did but it didn't like spitting out just the formula, it had to explain it even when explicitly asked.
Works beautifully for what i needed. Also domain specific Salesforce formulas. Makes my life 100 times easier. I'll become paying user for this alone.
aside from the tech, I also really like the examples (e.g. cleaning addresses), they are practical uses of GPT. Gave me some ideas too!
When are webhooks going to be released? Webhooks inside a spreadsheet would be :fire: (looks like emojis don't work on HN, SMH).
also subscription via websockets! it’s an interesting new trend.
(comment deleted)
(comment deleted)
I use this, Rows.com is very cool stuff. Not (yet) a full replacement for G Sheets but 10x better for widgets and interactive tables and reports.

And the built in forms are excellent!

... :chef: :kiss:

No emojis ;-[

(comment deleted)
Seems like they have sort of a Notion-like approach to spreadsheets

I agree it's pretty cool. What I'd really love to see though is something like Jupyter Notebooks + Spreadsheets. If blocks of code and blocks of spreadsheets could talk to each other, it'd definitely be a killer feature for me

I'm not sure if this is what you're looking for, but Grist has relationship-driven spreadsheets where the formulas are all Python code. And you can have multiple tables show on the same page, where selection of one filters the others.

The tables are more database-style than pure unstructured Excel sheet style, but I've found that having a full Python environment in each cell to be pretty powerful, and I've started turning to it for analytical work because I can avoid the mess that larger Excel formulas can turn into.

No relationship except as a customer -- they're at getgrist.com

Looks cool too! Python!!
Ooh, excited to see mention of Grist (I am a cofounder). Python code and structured data are a great combination, and are particularly good for AI. We did an experiment where AI was quite impressive in writing Python formulas in Grist based on simple prompts: https://news.ycombinator.com/item?id=33809111

I suppose it's similar to rows.com's ASK_OPENAI("write a spreadsheet formula that..."). Most impressive is that it knows relationships between tables, and can construct correct lookup formulas, and do useful things with their results.

really cool! fyi, i'm having trouble clicking on certain cells in the demo.
(comment deleted)
which cells? example?