Forum Discussion

THough335's avatar
THough335
Copper Contributor
Aug 08, 2023

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!

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

    • THough335's avatar
      THough335
      Copper Contributor
      Worked beautifully! Thank you for your assistance. You help is greatly appreciated!

Resources