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 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.
- THough335Copper ContributorWorked beautifully! Thank you for your assistance. You help is greatly appreciated!