Hi,
I can’t get the formula to work. Can we do condition formula on Single select option?
Example;
Single select option
Category
A
B
I’ve tried, IF(Category=A / IF(Category=‘A’ & IF(Category=“A” but none work. Please help.
What I need is; IF Category is A, “Yes”, Else “No”
I have no problem for digits, but stuck for text.
Thank you.
HI @Bab_Bit and welcome to the community!
Try
IF(Category=“A”, “Yes”, “No”)
ps: be sure to check you didn’t add a space after your options in your select field!
HI @Bab_Bit and welcome to the community!
Try
IF(Category=“A”, “Yes”, “No”)
ps: be sure to check you didn’t add a space after your options in your select field!
Hi, thank you.
It still doesn’t work. It should be straightforward, not sure why still doesn’t work.
HI @Bab_Bit and welcome to the community!
Try
IF(Category=“A”, “Yes”, “No”)
ps: be sure to check you didn’t add a space after your options in your select field!
IF(Category="A", "Yes", "No") works fine for me.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.