Aug 08 2023 03:33 PM
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!
Aug 09 2023 01:32 AM
Solution@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.
Aug 09 2023 07:04 AM
Aug 09 2023 01:32 AM
Solution@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.