SOLVED

# SharePoint Calculated column with IF statement

Copper Contributor

# 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 nothing I can think of works.

=IF([ISP Only]="Yes"), "ISP",TEXT([On Air Begin],"mm/dd/yy")&" - "&TEXT([On Air Last],"mm/dd/yy"))

I would like On Air Between to state ISP if ISP only is "Yes" but otherwise I'd like to combine the dates as text like it does for the rows indicated with AIRTIME.

Extremely grateful for any assistance!

2 Replies
best response confirmed by THough335 (Copper Contributor)
Solution

# Re: SharePoint Calculated column with IF statement

@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.

# Re: SharePoint Calculated column with IF statement

Worked beautifully! Thank you for your assistance. You help is greatly appreciated!
1 best response

Accepted Solutions
best response confirmed by THough335 (Copper Contributor)
Solution

# Re: SharePoint Calculated column with IF statement

@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.