Help me to fix this problem

[Wais_alqarni]

ifs(“spbj”=[KATEGORI],[spbj],“spk”=[KATEGORI],[spk],“SPK MULTIYEARS”=[KATEGORI],[SPK MULTIYEARS])

[Izzat_Safrah]

Hi @Wais_alqarni

Try to finish your expression by FALSE

ifs(“spbj”=[KATEGORI],[spbj],“spk”=[KATEGORI],[spk],“SPK MULTIYEARS”=[KATEGORI],[SPK MULTIYEARS],FALSE)

[Wais_alqarni]

it’s not working

[hru · Accepted solution]

try this:

IFS(
	"spbj"=[KATEGORI],TEXT([spbj]),
	"spk"=[KATEGORI],TEXT([spk]),
	"SPK MULTIYEARS"=[KATEGORI], [MULTIYEAR]
)

[Wais_alqarni]

You’re the best. Thank you sooooooo. much!!!