ifs(“spbj”=[KATEGORI],[spbj],“spk”=[KATEGORI],[spk],“SPK MULTIYEARS”=[KATEGORI],[SPK MULTIYEARS])
Solved! Go to Solution.
try this:
IFS(
"spbj"=[KATEGORI],TEXT([spbj]),
"spk"=[KATEGORI],TEXT([spk]),
"SPK MULTIYEARS"=[KATEGORI], [MULTIYEAR]
)
Try to finish your expression by FALSE
ifs(“spbj”=[KATEGORI],[spbj],“spk”=[KATEGORI],[spk],“SPK MULTIYEARS”=[KATEGORI],[SPK MULTIYEARS],FALSE)
try this:
IFS(
"spbj"=[KATEGORI],TEXT([spbj]),
"spk"=[KATEGORI],TEXT([spk]),
"SPK MULTIYEARS"=[KATEGORI], [MULTIYEAR]
)
You’re the best. Thank you sooooooo. much!!!
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |