Forum Discussion
Calculated Column with Brackets
I have: =[Tool Number]&"([Customer Tool Number])". I would like the second value to appear in brackets as the example below:
T123 (T456)
3 Replies
jamescosten Use calculated column formula like this:
=[Tool Number]&" ("&[Customer Tool Number]&")"Output:
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.
ganeshsanap Brilliant Thank you. Just out of curiosity is it possible to add an ISBLANK then dont show the bracketed value? If not I can just put an N/A value in sp list.
jamescosten Yes, use formula like:
=IF(ISBLANK([Customer Tool Number]),[Tool Number],[Tool Number]&" ("&[Customer Tool Number]&")")Output:
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.
