samedi 14 décembre 2019

How to find Google Sheets pivot table's colum header?

I have a pivot table in google sheets which uses "shirts names" as it's columns headers, "people names" as it's rows headers. The value should be different in every cell - The sheet gets info about a person and which shirt did he take. In the pivot-table's cell aligned with the person's name, and the name of the shirt, needs to be written "used" or "available". What I came up with is the following:

=IF('stats'!D8="borrowed",IF(B2 = 'stats'!E8, "used", "available"))

in stats:

D8 = "borrowed"

E8 = shirt's name

B2 is supposed to be the pivot table's header of column - the shirt's name.

The formula I wrote is actually the value in every cell in the pivot's table, so every cell needs to somehow understand which column is he in.

Aucun commentaire:

Enregistrer un commentaire