Hello, I have a small question. I have a column that should change if another column has data. For example. If column "X" is equal to "X" value. So the value should be "A"
But if column "X" and column "Y" have "X" value then it must be "B"
And lastly, if column "X" and column "Y" and column "Z" have "X" value then it should be "C"
No formulas on the sheet. Everything in the app
Solved! Go to Solution.
Hello, in this case you should go with formula IFS and AND, example:
IFS( AND(
ISNOTBLANK([column X]),ISBLANK([column y]), ISBLANK([column z])),
"A",
AND(
ISNOTBLANK([column y]), ISBLANK([column x]), ISBLANK([column z])),
"B",
ISNOTBLANK([column z]), ISBLANK([column x]), ISBLANK([column y])),
"C"
)
Here my logic is: if is not empty or blank the column x bu the others are, return A... If is not blank the column y, but the others are, return B, etc.
This is the logic I see in it
Hello, in this case you should go with formula IFS and AND, example:
IFS( AND(
ISNOTBLANK([column X]),ISBLANK([column y]), ISBLANK([column z])),
"A",
AND(
ISNOTBLANK([column y]), ISBLANK([column x]), ISBLANK([column z])),
"B",
ISNOTBLANK([column z]), ISBLANK([column x]), ISBLANK([column y])),
"C"
)
Here my logic is: if is not empty or blank the column x bu the others are, return A... If is not blank the column y, but the others are, return B, etc.
This is the logic I see in it
Muchas gracias It worked perfect
Not a problem. Put your IF expression into the Formula bar of the column (not the initial value) You may also want to consider making this column a virtual column, since it is calculated based on other columns.
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
11 |