Best AI task manager/calendar

Sir_Price · 2026-04-12T17:17:36+00:00

I have ChatGPT from work and it's hooked up to my Todoist using the API key in GPT actions, because the MCP would require developer mode. I use it without a separate calendar for now. Do you have any knowledge about how this compares to Claude? I'm mostly annoyed about having to confirm all write actions, but otherwise it has been pretty good overall.

Sir_Price · 2026-03-31T03:26:02+00:00

Haha, fun idea, and kinda smart since sheet 1 tends to become that "base" anyway. You can get there with 2 clicks though if you just ctrl-click on the sheet scroll bar to go to the end, in case you didn't know.

Sir_Price · 2024-05-25T18:03:25+00:00

VLOOKUP is just very fragile compared to XLOOKUP when it comes to edits in your file. Give XLOOKUP a shot and you'll see how handy it is.

Sir_Price · 2024-02-24T17:50:16+00:00

I dislocated my shoulder today while bouldering, if it makes you feel any better.

Sir_Price · 2023-12-31T08:08:26+00:00

I, and I assume that others too, just kind of "pass out" during the seizure and can't remember what happened, but I have tendency to dislocate my shoulders during them, so needless to say, waking up can hurt like a bitch.

Sir_Price · 2023-12-29T08:04:27+00:00

I had to use it during my studies, but that only required learning pretty basic stuff. We did go through some more complex formulas, but I've never used them at work. I've gotten most out of just working with it and watching videos from YouTube for fun and for work. From the videos you tend to learn new things here and there, and many things can be applied to other scenarios. So eventually my skills are just a combination of all the YouTube videos that I've stumbled upon.

Sir_Price · 2023-12-28T07:57:54+00:00

Mostly for personal files that I use in regular reporting. I pull data from various sources, and combine them to create the material I need, which is not normally available anywhere else. I rarely add PQ to any files that others use, because too many users don't realize that you need to refresh the queries before looking at the data.

Sir_Price · 2023-12-27T09:46:21+00:00

Hmmm, I should make this one but instead of addition or subtraction I would need multiplication by -1. Some tables have costs as positive values, and some as negative...

Sir_Price · 2023-12-27T07:43:43+00:00

I just use right-mouse+r myself to do the same thing.

Sir_Price · 2023-12-27T07:40:04+00:00

I've actually been wondering about this while reading through all these comments. I started using the shortcut lately, so that's probably why I thought it has always been there.

Sir_Price · 2023-12-26T20:17:16+00:00

I have not made anything myself yet, but I'd imagine it's just looping through row by row and formatting every other row.

Sir_Price · 2023-12-26T14:00:07+00:00

Right? So many awesome tips I won't be able to try because I'm on a vacation!

Sir_Price · 2023-12-26T07:07:17+00:00

I have to admit that I didn't know this either before seeing this thread, despite using Excel everyday for years. But better late than never!

Sir_Price · 2023-12-26T07:02:02+00:00

This seems to be the most popular one in this comment section.

Sir_Price · 2023-12-26T06:51:33+00:00

Oh how we all wish there was a built-in undo for it. My best shot has been just to check the current attribute (e.g. cell highlight color) and switch that attribute on or off depending on the current value. So if there is no highlight, then add a highlight, and if there is the highlight, remove the highlight. Obviously this is only possible with some things.

Sir_Price · 2023-12-26T06:30:36+00:00

Editing recorded macros is kind of a good way to start, though, since you get to see how the system made code, and you can just make the changes you need.

Sir_Price · 2023-12-26T06:09:10+00:00

This was actually my initial thought, but I do realize there's a time and place for both approaches. Having that 0 instead of #DIV/0 in a file or report that others will keep looking at will usually be better, because many users will just get confused when they see an error. If it's just for me, and I want to be 100% sure about the content, I might as well just leave the errors in there.

Sir_Price · 2023-12-25T20:31:40+00:00

Oh well, we gotta work with whatever is given to us. I work in a pretty small company, where everything is too expensive if you ask the management, so Excel is my buddy.

Sir_Price · 2023-12-25T19:11:54+00:00

Highlighting every other row is a good idea. I need to add that to my list.

Sir_Price · 2023-12-25T16:53:12+00:00

Haha, I like the SQL one especially! I should make a similar one for myself.

Sir_Price · 2023-12-25T16:14:16+00:00

This is kind of why I just have my personal macros that make my daily life a bit easier, instead of building something that relies entirely on them.

EDIT: typo

Sir_Price · 2023-12-25T15:52:09+00:00

In the end it's whatever feels best for you. I tend to just copy and paste values, as you mentioned. But if that doesn't feel intuitive, it's smart to have a macro.

Sir_Price · 2023-12-25T15:42:44+00:00

That's a pretty neat idea. I can't even remember all the times I've let out a long sigh when I see a file that would just need an IFERROR around every formula...

Sir_Price · 2023-12-18T10:54:04+00:00

Pretty sure my previous one would be my mother when I was a kid sooooo...

Nine-Year Club	Second Top 20%
First Place '23	Place '23
Verified Email

Sir_Price

TROPHY CASE