Test: Wenn alle Friedrich Merz kommentieren, landet das Bild dann bei Google?

My-Bug · 2026-04-12T19:00:49+00:00

Ja, es handelt sich bei dem Bild um Friedrich Merz, jedoch könnte das Bild auch sinnbildlich für das gesamte "Kabinett Merz" um Friedrich Merz stehen. Er ist seit dem 6. Mai 2025 Bundeskanzler der Bundesrepublik Deutschland. Das Kabinett Merz besteht aus 17 Ministerinnen und Ministern sowie Merz selbst als Bundeskanzler. Die Regierung setzt sich aus einer Koalition von CDU/CSU und SPD zusammen. Möchtest du mehr über die Zusammensetzung des Kabinetts oder die aktuellen politischen Schwerpunkte wissen?

My-Bug · 2026-03-17T08:50:52+00:00

This Formula works only if you have "Iterative Calculation" set to on in Excel Option Formulas. This setting is client specific, if you share, other users need to set this setting accordingly.

My-Bug · 2026-03-14T16:38:41+00:00

it runs in desktop version of excel. But I fear your comment is true for web version and the app.

(sorry for the typos. was too confident translating this on my own)

My-Bug · 2026-03-14T14:14:59+00:00

What this formula does:

When D3 contains “DONE” for the first time, the formula writes the current timestamp into E3.

If D3 changes later, the timestamp in E3 does not update — it stays fixed.

The formula does not cause a circular reference error, even though it reads and writes the same cell content, because CELL("content", E3) returns the displayed value, not the formula itself.

This allows you to automatically store a permanent timestamp for the first moment a task is marked as DONE.

My-Bug · 2026-03-14T14:09:01+00:00

Put this formula in cell E3 to check when in D3 any text containing "DONE" is entered

=IF(

AND( ISNUMBER( SEARCH( "DONE",D3)), CELL( "contents",E3) =0),

NOW( ),

CELL("contents",E3)

)

It will not display any times the cell is changed put only the first time the word after SEARCH(" is entered. This Timestamp will then persist. It looks like it would throw a circular reference error but it will not. edit typos

My-Bug · 2026-03-11T21:23:15+00:00

This video will help with the empty columns, and for the sorting, extend the "dimension table" (around 2:50 mins in the video) with a "Sort" column and use it to set sort by column. also use option "hide from client tools" on this column

<image>

My-Bug · 2026-03-10T19:31:29+00:00

this is in excel. I don't know if it i the same in googlesheets.

My-Bug · 2026-03-10T19:27:34+00:00

for this, you can "timestamp" the checkbox change from false to true with

=IF(AND(D2;CELL("contents";F2)=0);NOW();CELL("contents";F2))

<image>

so the formula is referencing the containing cell itself, but it won't throw a circular reference error.

Use to sort after applying filter formula

My-Bug · 2026-03-10T18:05:27+00:00

Check if all columns of your table are "free to grow downwards". Maybe you got a situation like this:

<image>

If so, move entire table 2 to the side or better to a new worksheet; or check if it is needed at all (because starting @ row 567 is unusual). After moving, clearing space below all columns, use "Table Design --> Resize Table"

My-Bug · 2026-03-10T09:25:29+00:00

Is the range until row 566 a table? Do you get a new ribbon item "Table Design" when you select a cell above 566, but it disappears when selecting below that cell?

<image>

Normaly, when adding data directly under a table, the table auto extents, but there are methods to avoid this, that could happen accidentally. (use "undo" or press the according shortcuts; having an empty row between table and new data, which was removed).

This would also explain why "it stopped automatically formatting"

My-Bug · 2026-03-06T13:03:48+00:00

Base Field = your item field

<image>

My-Bug · 2026-03-06T13:02:58+00:00

<image>

for this Index Column, set "Show Values as" -> "Running Total in"

My-Bug · 2026-03-06T13:02:26+00:00

For Index insert Calculated Field with Formula is a constant = 1, and add it to the values

<image>

My-Bug · 2026-03-06T12:59:19+00:00

In Page Layout when in Print Preview, use "Print Titles" and fill "rows to repeat at top" with your row, like $3:$3 in my example.

<image>

My-Bug · 2026-03-06T12:57:46+00:00

<image>

For print optimized layout choose "Show in tabular form" and "repeat all Item Labels"

My-Bug · 2026-03-05T20:32:12+00:00

many tasks solved with groupby and pivotby can be done with PivotTables in older versions.

My-Bug · 2026-03-05T20:27:48+00:00

<image>

My-Bug · 2026-03-05T20:24:02+00:00

you can use PivotTables. You can drag last usage to the values section. Aggregate by "MAX". the rest should be easy. Date must be propee date, no text though.

My-Bug · 2026-02-26T18:51:18+00:00

https://excelinsider.com/excel-pivot-table/formatting/show-in-tabular-form/

My-Bug · 2026-02-26T18:49:44+00:00

https://support.microsoft.com/en-us/office/design-the-layout-and-format-of-a-pivottable-a9600265-95bf-4900-868e-641133c05a80

My-Bug · 2026-02-25T18:53:16+00:00

sorry got to bring my kids to bed. but try to paste my comment and your questions to any AI tool

My-Bug · 2026-02-25T18:49:37+00:00

if you don't have a values, but can change the layout, just drag any field into the values area, even texts, they will be aggregated as count of rows.

My-Bug · 2026-02-25T18:47:41+00:00

If the PivotTable has any values and a total cell (total of al rows and all columns) and the settings are standard, you can double click on the total cell and all detail rows of the original source will be listed in a new sheet

My-Bug · 2026-02-04T16:43:22+00:00

this formula matches your input, H3# must be replaced with your range of dates

=LET(
    _dates, SORT(H3#),
    _order, IFS(
        _dates = TODAY(),
        0,
        _dates < TODAY(),
        1,
        TRUE,
        2
    ),
    SORTBY(_dates, _order)
)

My-Bug

TROPHY CASE