Forum Discussion
SP Calculated Column Formula Help
jonboylib The logic is, you have to add ISNUMBER(FIND(...)) part for each supplier inside OR() function.
You can have maximum 30 such conditions inside single OR function.
Can you explain further what is your requirement exactly? There might be another way to achieve it.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
I don't have a set number it will vary. I was just wondering what the logic would be.
Is there a limt to the number of embedded FIND I can use for example?
Thanks for your example it's very useful.
jonboylib The logic is, you have to add ISNUMBER(FIND(...)) part for each supplier inside OR() function.
You can have maximum 30 such conditions inside single OR function.
Can you explain further what is your requirement exactly? There might be another way to achieve it.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.