Forum Discussion
Solved
Sharepoint List - Single line of text starts with +49
Hi there, is there a way to define in an already created column "phone-number" which is the type (single line of text), that if a new assett is created, the value in the column must contain or st...
Its working now, I inserted the formula into the web page UI of the list and selected the column, as shown in the screenshot
=WENN(LINKS(Rufnummer;3)="+49";WAHR;FALSCH)Formula is working correctly:
Its working now, I inserted the formula into the web page UI of the list and selected the column, as shown in the screenshot
=WENN(LINKS(Rufnummer;3)="+49";WAHR;FALSCH)
Formula is working correctly:
Great, glad it worked for you. I was going to suggest you the same to use WAHR and FALSCH instead of TRUE and FALSE based on this documentation:
Documentation: WENN (Funktion)
Formula:
=WENN(LINKS([Rufnummer];3)="+49";WAHR;FALSCH)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.
