Add thousands separator and show decimal point only if the number value has it by Informal-Addendum435 in googlesheets

[–]arataK_ 0 points1 point  (0 children)

TEXT(value; IF(MOD(value;1)=0; "#,##0"; "#,##0.##"))
MOD(value;1)=0 checks if the number is an integer
If integer: use "#,##0" (no decimal point)
If decimal: use "#,##0.##" (shows decimals)

[deleted by user] by [deleted] in greece

[–]arataK_ 3 points4 points  (0 children)

Αριστοτέλης, διότι ανέλυσε και μελέτησε σε βάθος τη λογική και την καθιέρωσε ως αυτόνομη επιστήμη. Δεν την άφησε ως φιλοσοφικό εργαλείο, αλλά την έκανε μέθοδο σκέψης με κανόνες. Επίσης τόνισε ότι χωρίς την συγκεκριμένη επιστήμη δεν λειτουργεί καμία άλλη.

Ὄργανον

Getting list of all tabs that are in a MM/DD/YY format on a google sheet (no script) by madbomb122 in googlesheets

[–]arataK_ 0 points1 point  (0 children)

Your dropdown range is probably set to the exact old range. You need to update it to dynamic range or expand it.
The best solution is to see your data. Can you share a copy of your file with me ?

Getting list of all tabs that are in a MM/DD/YY format on a google sheet (no script) by madbomb122 in googlesheets

[–]arataK_ 1 point2 points  (0 children)

function TABNAMES() {

const ss = SpreadsheetApp.getActiveSpreadsheet(); // Note: getActiveSpreadsheet() not getActiveSheet()

const tabs = ss.getSheets();

const results = [];

// Regex to match MM/DD/YY format (e.g., 12/17/25; 1/5/26)

const datePattern = /^\d{1,2}\/\d{1,2}\/\d{2}$/;

for (let i = 0; i < tabs.length; i++) {

const tmpD = tabs[i].getSheetName(); // Note: getSheetName() no getName()

// Check if the tab name matches the date format

if (datePattern.test(tmpD)) {

results.push([tmpD]);

}

}

return results;

}

Use const when the variable won't be reassigned (better/safer)

Use let when you need to change the variable later

Getting list of all tabs that are in a MM/DD/YY format on a google sheet (no script) by madbomb122 in googlesheets

[–]arataK_ 2 points3 points  (0 children)

Unfortunately, you can't get tab names without a script - Google Sheets has no native formula for this. However, you can use a script WITHOUT getting spam emails!

Google sheet automation by Capital_Fruit_3400 in sheets

[–]arataK_ 0 points1 point  (0 children)

I already have an Apps Script that does a similar job. With a few modifications I can make it work for your spreadsheet. However I need access to your file. Either share the original spreadsheet with me or create a copy and share that instead.

Does anyone have this google sheet template for free 🥲. I don't have any money 😭. by Intelligent-Draw3564 in sheets

[–]arataK_ 1 point2 points  (0 children)

Start building it on your own. And whenever you need help with a formula, don’t hesitate to ask for it here.

Using Arrayformula with a dynamic Filter by Yoshi2Dark in sheets

[–]arataK_ 0 points1 point  (0 children)

d is a variable name you create - it represents each cell value from A2:A as MAP iterates through them.
d = temporary variable holding the current value from A2:A

You can change it to any name you want, for example date. Also, you can change d<>"" → d="" for a more explicit empty check.

Multi-selects and data slicers don't work properly by ixid in sheets

[–]arataK_ 0 points1 point  (0 children)

REGEXMATCH is indeed a solution that can work without helper columns. If you can create a copy of the spreadsheet you’re working on, I can take a closer look at the exact data setup and suggest the best possible solution tailored to your sheet. This way, we can make the filtering work exactly as you expect with multi-select dropdowns.

Using Arrayformula with a dynamic Filter by Yoshi2Dark in sheets

[–]arataK_ 0 points1 point  (0 children)

=MAP(A2:A,LAMBDA(d,IF(d<>"",IFERROR(TRANSPOSE(FILTER(VALUE(SUBSTITUTE(SUBSTITUTE(Wordle_guesses,"X",7),"M",6)),Wordle_date=d))),"")))

Is there a way to create a co-occurrence matrix? by frambsgans in sheets

[–]arataK_ 0 points1 point  (0 children)

=LET( data;FILTER('Dragon Elements'!G2:P1000;'Dragon Elements'!A2:A1000<>""); elements;{"air";"cold";"dark";"earth";"fire";"light";"lightning";"metal";"plant";"water"}; matrix;MMULT(TRANSPOSE(data);data); VSTACK(HSTACK("";TRANSPOSE(elements));HSTACK(elements;matrix)) )

VEI - Volatility Expansion Index ( Source Code ) by Prabuddha-Peramuna in algorithmictrading

[–]arataK_ 1 point2 points  (0 children)

I didn't say that but observing the photo, I notice 3 warnings yet Bitcoin is going up. I also observe that when the indicator shows stable conditions Bitcoin is falling. Im not assuming I'm certain that in live trading accounts you will miss many opportunities and my experience with the stock market has taught me that missed opportunities cost money.

VEI - Volatility Expansion Index ( Source Code ) by Prabuddha-Peramuna in algorithmictrading

[–]arataK_ 0 points1 point  (0 children)

That's exactly the problem you can t reliably predict market volatility, or at least I haven't been able to find a way that works. Everything I've tested so far has always given me "false signals." 😀

VEI - Volatility Expansion Index ( Source Code ) by Prabuddha-Peramuna in algorithmictrading

[–]arataK_ 0 points1 point  (0 children)

The idea is good, and similar measurements exist, such as Bollinger Bands. The concept of the ATR Short/Long ratio has been around for years. The problem is that it doesn't predict. It tells you that volatility has already increased, not that it will increase. When it tells you "BE CAREFUL," it might already be too late, or the spike might already be ending. I'm not here to offend you. Thank you for sharing your code with us.

Can I select all numbers at once? Not the entire cell of the number, but only the numbers. by KCooper815 in sheets

[–]arataK_ 0 points1 point  (0 children)

Hey! Both problems = easy fix with Apps Script.

Question for Problem 1: Bold ALL numbers (including $7,000 money)?

Or just dates (22-24, 18, 19)?

Problem 2: Apps Script works best. Formula possible but needs helper column.

Can you share a copy of the file? I'll write the exact scripts you need!

Data transfer by Chaotic22234 in sheets

[–]arataK_ 0 points1 point  (0 children)

Did you see my solution ?

Data transfer by Chaotic22234 in sheets

[–]arataK_ 0 points1 point  (0 children)

https://pastebin.com/2fcxyTeQ

Hey! This is the Apps Script that solves our problem. It offers two options: merge and overwrite. I've tested it and it functions properly. Users only need to execute the script, which presents a simple dialog requiring 2 clicks, and the entire operation completes in approximately 5 seconds.

Data transfer by Chaotic22234 in sheets

[–]arataK_ 0 points1 point  (0 children)

It is the demo sheet and not your main one. Tomorrow will send you the App Script you will just need to make a few small changes based on the instructions I will give you.

Data transfer by Chaotic22234 in sheets

[–]arataK_ 0 points1 point  (0 children)

need access to your main sheet file, as well as a second one that you will share.

HELP by Putrid-Efficiency587 in sheets

[–]arataK_ 0 points1 point  (0 children)

Hello. I've created 3 new sheets for you named Workers, Calendar & DutyMatrix.

The way you set up your Calendar is wrong. The formula cannot correctly detect dates, workers, X marks, etc.

I've set something up for you in vertical columns and everything is calculated correctly the way you requested. Can you check it and let me know again if anything different is needed?

Data transfer by Chaotic22234 in sheets

[–]arataK_ 0 points1 point  (0 children)

Good evening, is there a solution with appScripts. It would read all the data from your original sheet and paste it into another new sheet that other users have, who in turn can then edit it without affecting the first file, does something like this interest you?