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