multiple selections of long text
I want to make a multiple selections in my IF function, I am aware of CHAR(10) function. However, it does not work in my case, I am suspecting it is because of the selection I want is a string of text but not sure. Please see example below.
=IF([Select all items needed]@row = "Form No. 1234/1234A" + CHAR(10) + "Data collection forms such as 225A, 1234, 225C", 1, 0)
Any suggestion is appreciated.
Help Article Resources
Check out the Formula Handbook template!