How Can I Use TEXTJOIN Function in AppSheet
Here Is Spreadsheet Formula
IF ([ColX] =“Abc”, textjoin(" ",1,"Xyz @ “& [ColA] &” - “&[ColB] , [ColC] , [ColD] , [ColE] &” @ " & Round ([ColZ] , 0) , [ColY] ), “”)
I want to Join Column In Some Cases May be Some Column can Be Empty
So To Avoid Extra Space in Output I want to Leave out Empty Column
Is This Possible in AppSheet Expression?
Waiting for quick Reply