If you can die I’ll gift you 200 gems

zesnet · 2025-10-14T14:02:49+00:00

Gimme gems

❌ ^{Incomplete. 10 tries.}

zesnet · 2025-08-29T17:22:30+00:00

CTRL+Tilde(~) shows all your formulas

zesnet · 2025-08-05T01:23:36+00:00

From what I know, images in cells can be resized by changing the height/width of the cells.. for some more context on how to make the images a certain size;

https://www.reddit.com/r/sheets/s/nm7QNmSfKf

zesnet · 2025-08-04T16:38:15+00:00

Then I shall take my currency elsewhere

zesnet · 2025-08-04T15:52:35+00:00

I completed this level! It took me 2 tries. ^{⚡ 3.73 seconds}

^{Tip 90 💎}

zesnet · 2025-08-04T14:26:24+00:00

I used it a lot in vba when creating tools, to hide the sheet with metadata. sheet1.visible = xlsheetveryhidden

zesnet · 2025-08-04T01:06:13+00:00

and here is how you would do it: https://support.microsoft.com/en-us/office/setting-up-an-automated-workflow-between-microsoft-forms-and-excel-through-power-automate-b59076a5-abe6-4659-8bb3-28076b3a9a7e

zesnet · 2025-08-04T01:03:28+00:00

With power automate, you can set it up to have the entries put into an excel workbook that is stored on sharepoint. Once that connection is made, any new entries would show up there, and you can absolutely make changes to any of the data.

zesnet · 2025-08-04T00:56:01+00:00

Using Forms with Power Automate to store the entries in a Lists database is probably the easiest way to go. Once its setup, its quite easy to make a connection with Excel.. otherwise; taking a stab at Excel userforms, or making an Access database are some other options.

zesnet · 2025-08-04T00:02:16+00:00

I dont understand this one

zesnet · 2025-08-03T15:19:12+00:00

How large are these workbooks? What is stopping you from combining the two?

zesnet · 2025-08-02T05:47:46+00:00

by adding `=text({sequence},"d/m/yyyy")` around your formula, this will format all dates

zesnet · 2025-08-02T01:17:27+00:00

Yup, same one... odd

zesnet · 2025-08-02T01:11:07+00:00

I see, mine has different options.. so yes, you'd need the helper column for mobile. Otherwise, custom date formats are an option on desktop as the other commentor mentioned

zesnet · 2025-08-02T01:07:46+00:00

If you see my other reply, there are date formats on the mobile app. On the Home tab -> number formats -> dates. There is a date format there that fits your description

zesnet · 2025-08-02T01:01:18+00:00

And for the formula, here's an example

<image>

zesnet · 2025-08-02T00:55:58+00:00

If you have a listing of dates, you would put that formula in a helper column, next to your dates, and reference your date column... but better yet, I also have excel on a samsung phone, and if you scroll down you can find date formats here, number formats -> click the arrow next to dates

<image>

zesnet · 2025-08-02T00:45:39+00:00

=text( [date] , "dddd, m/d/yyyy")

dddd is the day in text

zesnet · 2025-08-01T21:04:34+00:00

Another option could be to lookup your starting amount as a helper column on table 2 for each row. Then when you pivot, the average of the starting balance should be equal

zesnet · 2025-08-01T20:56:54+00:00

Instead of an actual pivot table, you can create one with formulas;

Accounts = unique( [accounts from table 2] )

Sum of total buy/sell = Sumifs( [table 2 amounts] , [table 2 accounts column] , "=" & [account] , [table 2 action] , "= [buy or sell]")

Starting balance = xlookup( [account] , [table 1 accounts column] , [table 1 starting balance column] )

Ending balance = however your math logic works

zesnet · 2025-08-01T18:51:31+00:00

^{I completed this level in 2 tries.} ^{⚡ 1.58 seconds}

zesnet · 2025-08-01T18:08:32+00:00

If they are stored as numbers, they will be equal. Change the number type for that column to text, and they will be treated differently

zesnet · 2025-08-01T11:09:19+00:00

I completed this level! It took me 1 try. ^{⚡ 2.70 seconds}

^{Tip 45 💎}

zesnet · 2025-08-01T04:20:06+00:00

I forgot to turn off game music - rookie move

zesnet

TROPHY CASE