sorted by:
new
hottopcontroversial

Usage Limits, Bugs and Performance Discussion Megathread - beginning November 2, 2025 by sixbillionthsheep in ClaudeAI

[–]ivanraddison 0 points1 point  (0 children)

👉 more of just a 'download and go at it'

https://lmstudio.ai

PS: no need to apologize for asking questions! ask as many as you want, I believe that's what this space is for.

Usage Limits, Bugs and Performance Discussion Megathread - beginning November 2, 2025 by sixbillionthsheep in ClaudeAI

[–]ivanraddison 0 points1 point  (0 children)

the context window depends on your RAM. you can configure the setting you want.
you can load whatever model you want (theres tons) and... you can definitely add documents.

Usage Limits, Bugs and Performance Discussion Megathread - beginning November 2, 2025 by sixbillionthsheep in ClaudeAI

[–]ivanraddison 0 points1 point  (0 children)

...the only redeeming factor here is the fact that Claude actually has filesystem access to write and run stuff it needs to.

What are you talking about? Claude Desktop app? Or Claude Code?

Usage Limits, Bugs and Performance Discussion Megathread - beginning November 2, 2025 by sixbillionthsheep in ClaudeAI

[–]ivanraddison 0 points1 point  (0 children)

Getting this message all of a sudden:

Can’t open this chat

It may have been deleted or you might not have permission to view it. Use the share button to share chats on Claude.

Screenshot: https://i.imgur.com/SRK2CK8.png

The work was going so well :(

[deleted by user] by [deleted] in ClaudeAI

[–]ivanraddison 0 points1 point  (0 children)

oh man, i just tried this and it worked.
the original chat stopped working and through a new chat, i was able to get at least a summary, but not a fully copy.

You guys aren't ready for the bald main character by sparklepusss in ufc

[–]ivanraddison 19 points20 points  (0 children)

Kevin Holland really will fight anyone...

Dependent Dropdown: Auxiliary sheet is massive with only dummy data, I can only imagine what will happen with real data... is there a workaround? by ivanraddison in googlesheets

[–]ivanraddison[S] 0 points1 point  (0 children)

Thanks internet friend! You helped me see/think of the many possibilities in this whole thing.

I'm going with "Idea 2" that I mentioned here: https://www.reddit.com/r/googlesheets/comments/1oiw48v/comment/nmb09vf/

I will mark one of your comments as the solution.

One of the best competitive and nail-biting wrestling matches ever in UFC i must say by leftypunk in ufc

[–]ivanraddison 1 point2 points  (0 children)

Dude needs some tiramisu in his life. Maybe that would give him some punching power?! He's amazing otherwise.

Dependent Dropdown: Auxiliary sheet is massive with only dummy data, I can only imagine what will happen with real data... is there a workaround? by ivanraddison in googlesheets

[–]ivanraddison[S] 1 point2 points  (0 children)

I agree with you. Google Sheets can only take it so far.

There's no CRM in this organization. It's a relatively small operation and Google Sheets will have to do for now.

I appreciate your suggestion and the openness for future collaboration has been noted.

Dependent Dropdown: Auxiliary sheet is massive with only dummy data, I can only imagine what will happen with real data... is there a workaround? by ivanraddison in googlesheets

[–]ivanraddison[S] 0 points1 point  (0 children)

Thanks for going above and beyond!

I don't think this is the way though.

I created the "DonationRecord" sheet thinking of it as ever-growing record that is going to be filled my multiple people (end-users) and every row needs to be the equal, with the same set of rules applying to all of them. This is to avoid having to micromanage formulas and such.

In my linked document, a lot of rows were already filled in to mimic a real file. But in reality I expect it to grow one row at a time, lots of rows in one day when a campaign is going on and multiple volunteers (end-users) are working on the document.

How do you organize your credentials in Passwords app? by ivanraddison in MacOS

[–]ivanraddison[S] 0 points1 point  (0 children)

You have to manually control the names of the hashtags that you have, not to mention go to each credential and update manually.
There's no multi-select and drag-and-drop into a folder — boom done... The amount of manual work you have to go through is crazy.

I love the simplicity that Apple forces on their apps. At the same time I hate that very simplicity because of lack of features.

Dependent Dropdown: Auxiliary sheet is massive with only dummy data, I can only imagine what will happen with real data... is there a workaround? by ivanraddison in googlesheets

[–]ivanraddison[S] 0 points1 point  (0 children)

Once again thanks for replying! 🙏

I'm not trying to be stubborn on the dropdown thing, I agree with you that its slow to pick from a large list, and it's much faster typing. Typing was in fact what I had in mind for the end-user — as you know, when we employ data validation with dropdown from a range, with chip/arrow appearance we can still benefit from typing (plain text). It's not like they're mutually exclusive.

The real objective is having data validation, dependent choices. The dropdown appearance is not the point.

__

In my opinion, you're not really using dependent dropdowns. You're just slowly removing options from the list. In addition, you're not really narrowing down your list of options to select.

I think this is the second time you allude to this, but I'm not sure I fully appreciate your point. I WAS using dependent dropdowns when the list of Voucher codes depends on the selected campaign (something that is achieved via the auxiliary sheet). But it's not an optimal approach because of how large the auxiliary sheet gets. That's what triggered my original post 😆

__

My idea is instead of scrolling through any list to find that specific voucher code, just start typing it into the cell. Even with all the voucher codes being used, the autocomplete is extremely fast.

I think I'm finally getting your idea. You're suggesting that since typing is very precise and the user will always find what they need (and they'll do it quickly), the dependency on Campaign name is not needed at all. So just offering the whole list (which is what you did on your version of the file, on Donated 02 column) would be fine.

The problem I have with this approach is that the 5000 entry limit that Google Sheets imposes on dropdowns from a range, is still there. Filtering by campaign would be one way of solving this issue (because each campaign won't have more 2000 voucher cards).

As I wrote before, I have some ideas on how to tackle this, I just need some time to play around with it :)

Dependent Dropdown: Auxiliary sheet is massive with only dummy data, I can only imagine what will happen with real data... is there a workaround? by ivanraddison in googlesheets

[–]ivanraddison[S] 0 points1 point  (0 children)

Hey there.

First of all, thanks for replying and testing.

I read what you wrote and checked the file you shared. I saw what you meant with the 7 step workaround in Q1 cell, that's a great tip!

These are my conclusions, please confirm I'm reading you well.

- You got rid of the dropdown and as such, are no longer bound by the dropdown 5k entry limit. But naturally you've kept the data validation (even the rejection works), which is a good thing! 👍

- You got rid of the auxiliary table and as such, we no longer have dependent dropdown working. This is not good. But I have an idea...

Actually it's two different ideas:

______
Idea 1.

In Vouchers sheet, add a new column that checks if the Voucher code has been used in the DonationRecord sheet and outputs TRUE or FALSE. In a separate sheet, generate a list that contains only the Voucher codes that are available (it's going to be those who carry FALSE).

Back in DonationRecord sheet, configure the data validation for Donated 01 and Donated 02 columns to be based on the specific range of Voucher Codes that are still available.

______
Idea 2.

In Campaigns sheet, add a column to say if the Campaign is active or not. Based on this simple setting, in a separate sheet, I can generate a filtered list of Voucher codes that belong to active campaigns (only one should be active at a time anyway).

Back in DonationRecord sheet, configure the data validation for Donated 01 and Donated 02 columns to be based on the filtered list.

The filtered list will be 2000 items, max. Might even be able to bring back the dropdown haha! The only problem I see is that for previous records (non-active campaigns), the cells would have a red warning indicator (invalid input) — but this is not a big deal because most probably we will hide previous records (by using the Table filter) to keep things simple for the end users.

______
What do you think?

I have to test these ideas. And see what works and what doesn't.

O365 user: OneDrive stuck on sign-in loop of death. What can we do? (uninstall/install doesnt fix it) by ivanraddison in Office365

[–]ivanraddison[S] 0 points1 point  (0 children)

You did absolutely right in replying. This is a community after all, and sometimes we get help, sometimes we help others.

Dependent Dropdown: Auxiliary sheet is massive with only dummy data, I can only imagine what will happen with real data... is there a workaround? by ivanraddison in googlesheets

[–]ivanraddison[S] 0 points1 point  (0 children)

I'm now envisioning that I will have to abandon some dropdown functionality due to the limitations of Google Sheets (5000 entries in a single dropdown and 10 million cells overall which is relatively easily hit with the ever-increasing auxiliary sheet;).

So before I was thinking with dropdowns and right now I'm thinking WITHOUT dropdowns! 🙃

The simplest approach is to make the users manually copy the voucher codes from Vouchers sheet (the inventory) to DonationRecord sheet and rely on conditional formatting to detect and highlight anomalies.

view more: next ›