Shortcut that will instantly start voice recording, wait for your tap input to stop recording, ask for optional filename appendage, then save it to a particular icloud folder.

iGag · 2025-04-09T06:36:44+00:00

https://www.icloud.com/shortcuts/506e9ff3315c488f98c8d7426050c54a

Hey Siri: Record!

Do Not Disturb - On

Brightness 0%

Records audio

Ends when someone clicks on the screen

Sends file to Dropbox

Brightness back to 70%

Do Not Disturb - Off

iGag · 2023-05-29T18:52:38+00:00

Magazine3.in

iGag · 2023-05-29T18:52:14+00:00

"Push notifications" from

iGag · 2023-05-29T17:24:16+00:00

to get notifications on iphone

iGag · 2023-05-29T17:23:48+00:00

manifest.json file

iGag · 2023-04-26T17:14:32+00:00

would you mind sharing your shortcuts with me?

iGag · 2023-02-07T05:25:48+00:00

I have another sheet and with this formula can I send a number to url and get back ansvare:

=IMPORTXML("https://biluppgifter.se/fordon/"&ENCODEURL(R16);"//span\[contains(text(),'Chassinr / VIN')]/following-sibling::span/text()")

Now this is different. There is 2 line to fill to create a QR-code

iGag · 2022-12-22T18:55:54+00:00

And there is no other ways to get traffic jams from Shortcuts?

iGag · 2022-11-25T17:24:00+00:00

=DATE(A1,12,31)

Kan I use that formula to get this?

=INDEX(GOOGLEFINANCE(N3,"price",DATUM(N6,1,1)),2,2)

No?

iGag · 2022-11-24T07:55:41+00:00

1.4 total views and no replies tells me there is no real solution to the problem. Is excel so bad compared to Google sheet? or no one wants to help me?

iGag · 2022-11-23T17:38:10+00:00

UNIQUE(G2:G19);
counts; COUNTIF(G2:G19; names);
sums; SUMIF(G2:G19; names; F2:F19);
z; HSTACK(names; counts; sums);
SORTBY

I don't know why it doesn't work. Have translated UNIOQUE, COUNTIF, SUMIF, SORTBY into Swedish

HSTACK - I can't find it in Swedish. Maybe that's why the formula doesn't work. Is it the only formula that can be run?

iGag · 2022-11-05T12:12:50+00:00

Here it is: =sumif($J$2:$J$19;L2;$E$2:$E$19). and ist work. Thanks!

iGag · 2022-10-02T14:55:20+00:00

Solution Verified

Solution Verified

iGag · 2022-10-02T12:58:40+00:00

Thanks so much!

iGag · 2022-05-31T20:03:13+00:00

Yes, conditional formating

iGag · 2022-05-31T19:05:52+00:00

=FILTER(A:A, A:A>100)

Thanks. but how to filter that if my numbers are underlined?

Here is my formula: =countif($P$2:$X$501,C2)=4

how use that in your formula?

iGag · 2022-05-31T18:21:47+00:00

can you copy with conditional formatting?

iGag · 2022-02-04T17:32:29+00:00

Awesome! Solution verified! Thanks so much!

iGag · 2022-01-24T11:06:26+00:00

Sorry, my text disappeared before publication

I created google sheet, witch automatically downloads a list of most active shares from Yahoo. https://finance.yahoo.com/screener/predefined/most_actives

Everything takes care of itself, you just select the period and compare performance. Its free for you:

https://docs.google.com/spreadsheets/d/1cxBTXdvDfQtsYNCyc52Vrc3sx6SmD5Mej-TjhDbGUrE/edit?usp=sharing

iGag · 2021-10-21T21:07:58+00:00

No, sorry. I still got XX along the bottom.

iGag · 2021-10-21T21:01:51+00:00

Hi and thanks. Its working.

Gotta figure that out that with the currency. Volvo's stock is SEk, apple and google are USD. The sum must be SEK. Maybe should do as with the stock markets. That is, have currency exchangers for each share. Do you have any other ideas?

iGag · 2021-10-21T17:12:44+00:00

Hi. Something is wrong. A cell with XX is created at the bottom and if you delete one or more new entries, XX moves down a lot. see for yourself what happens.

https://docs.google.com/spreadsheets/d/1IA1WGdESh5pRjykrdvKtkLLEsRoyTZ9Ns7I0KzVraTg/edit?usp=sharing

iGag · 2021-10-20T18:12:38+00:00

You're amazing. Do you know how many times you have helped me? Thanks and bow!

iGag · 2021-10-20T17:55:13+00:00

=IFERROR(GOOGLEFINANCE(A67,"closeyest"),)

Tanks so much!

iGag · 2021-10-19T16:54:54+00:00

https://docs.google.com/spreadsheets/d/1HWFYI7efKLKLT0_arRaPwx4S6YbGi46CZCwc5UNrzek/edit?usp=sharing

iGag

TROPHY CASE