Return to Question

edited

Source Link

edited Jan 15, 2015 at 15:41

28.4k
5
32
61

First, I have very minimal formula writing skills (I'm trying to learn). I was able to create a SharePoint list and have a calculated column titled [Shimpment[Shipment Date Summary] with the following formula: ="On ”&[Date Shipment Changed]&" Shipment date changed from ”&[Prior Shipment Date]&" to ”&[New Shipment Date]

="On ”&[Date Shipment Changed]&" Shipment date changed from ”&[Prior Shipment Date]&" to ”&[New Shipment Date]

This formula works. However, if the columns are blank, my formatted text displays. How do I write a formula that returns a blank IF the fields I want to concatenate are blank ELSE maintain the formula operating as it currently is?
Furthermore, I will create a [Date Summary] column which will consolidate the [Shipment Date Summary] data (from formula above) as well as 2 other calculated formulas for [Order Date Summary] and [Arrival Date Summary].

Any help is much appreciated.

First, I have very minimal formula writing skills (I'm trying to learn). I was able to create a SharePoint list and have a calculated column titled [Shimpment Date Summary] with the following formula: ="On ”&[Date Shipment Changed]&" Shipment date changed from ”&[Prior Shipment Date]&" to ”&[New Shipment Date]

This formula works. However, if the columns are blank, my formatted text displays. How do I write a formula that returns a blank IF the fields I want to concatenate are blank ELSE maintain the formula operating as it currently is?
Furthermore, I will create a [Date Summary] column which will consolidate the [Shipment Date Summary] data (from formula above) as well as 2 other calculated formulas for [Order Date Summary] and [Arrival Date Summary].

Any help is much appreciated.

First, I have very minimal formula writing skills (I'm trying to learn). I was able to create a SharePoint list and have a calculated column titled [Shipment Date Summary] with the following formula:

="On ”&[Date Shipment Changed]&" Shipment date changed from ”&[Prior Shipment Date]&" to ”&[New Shipment Date]

This formula works. However, if the columns are blank, my formatted text displays. How do I write a formula that returns a blank IF the fields I want to concatenate are blank ELSE maintain the formula operating as it currently is?
Furthermore, I will create a [Date Summary] column which will consolidate the [Shipment Date Summary] data (from formula above) as well as 2 other calculated formulas for [Order Date Summary] and [Arrival Date Summary].

Source Link

asked Jan 15, 2015 at 15:36

Pspet

I need help writing a formula that concatenates fields (and adds text) but displays blank if all fields are blank

This formula works. However, if the columns are blank, my formatted text displays. How do I write a formula that returns a blank IF the fields I want to concatenate are blank ELSE maintain the formula operating as it currently is?
Furthermore, I will create a [Date Summary] column which will consolidate the [Shipment Date Summary] data (from formula above) as well as 2 other calculated formulas for [Order Date Summary] and [Arrival Date Summary].

Any help is much appreciated.

list column