Hi guys, I need to show column (QC* Question Column) depending on the value in other columns (AC* Answer Column), this is to show the next question only when all 4 players have answered, Q1 show Q2 pretty straight forwardโฆ AND([answer 1 Player 1] >0, [answer 1 Player 2]> 0, [answer 1 Player 3]> 0, [answer 1 Player 4]> 0)
But if there is only 3 or 2 players then the value of 3 or 4 player will always be 0 so it will not show, i have built a column with the number of player, so need a IF column Number of Player is equal to 2 player then check only 1 & 2, IF column Number of Player is equal to 3 player then check only 1, 2 & 3 etcโฆ
can anyone please guide me with this one
TIA
User | Count |
---|---|
36 | |
34 | |
27 | |
23 | |
18 |