Forum Discussion
SP Calculated Column Formula Help
- Jul 21, 2022
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.
jonboylib Try using below calculated column formula, it should work for you:
=IF(ISNUMBER(FIND("Amazon", [Supplier])), [Net], [Net] * 1.2)
Documentation: Examples of common formulas in lists
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.
- jonboylibJul 21, 2022Iron Contributor
- ganeshsanapJul 21, 2022MVP
jonboylib You need to add nested IF conditions for that.
Can you explain further about your requirements for adding more names? What should be the calculation (example: Net*1.2) for additional names?
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.
- jonboylibJul 21, 2022Iron Contributorganeshsanap
Ideally I would like to search for multiple suppliers. So rather than just Amazon, could I add more to list this, e.g. something like
=IF(ISNUMBER(FIND("Amazon", "Google", "Ebay", [Supplier])), [Net], [Net] * 1.2)