Forum Discussion
SharePoint Calculated column with IF statement
Please Please help! I am trying to merge multiple columns 2 of which are date columns [On Air Begin] and [On Air Last] and 1 is text column [ISP Only]. I've tried several variations of formulas but...
THough335 Use this formula:
=IF([ISP Only]="Yes","ISP",TEXT([On Air Begin],"mm/dd/yy")&" - "&TEXT([On Air Last],"mm/dd/yy"))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.
THough335 Use this formula:
=IF([ISP Only]="Yes","ISP",TEXT([On Air Begin],"mm/dd/yy")&" - "&TEXT([On Air Last],"mm/dd/yy"))
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.
- Worked beautifully! Thank you for your assistance. You help is greatly appreciated!
