I have a dropdown column that has the options “a”, “b”, “c” and “d” and a formula “If(dropdowncolumn#labels=“a”, 1, 0)”
If the dropdown is select “a” and “b” the fomula returns 0, becase it understand that it can only return 1 when the dropdown column is only “a”.
How can i creat this formula that returns 1 when the dropdown column contains “a” inspite having other labels or not
Hello @IvanGentil !
I believe this is what you are looking for:
IF(SEARCH(“a”,{Dropdown#Labels},1)>0,1,0)
Let me know if this helps!
Best Regards,
Giannis, Implementation Consultant at thespelas.com
2 Likes
Exactly, Thanks!!!
2 Likes