Part 1 (1st half of the formula, continued in the post below):
IF(Name, Name & ": ") &
IF({Address (with city)}, {Address (with city)} & " ") &
IF(
{Products Ordered},
"(" &
IF(
Product1,
Product1 &
IF({Product1 Quantity} > 1, "*" & {Product1 Quantity}) &
IF(
OR(
Product2,
Product3,
Product4,
Product5,
Product6,
Product7,
Product8,
Product9,
Product10,
Product11,
Product12,
Product13,
Product14,
Product15,
Product16,
Product17,
Product18,
Product19,
Product20,
Product21,
Product22,
Product23,
Product24,
Product25,
Product26,
Product27,
Product28,
Product29,
Product30,
Product31,
Product32,
Product33,
Product34,
Product35,
Product36,
Product37,
Product38,
Product39,
Product40,
Product41,
Product42,
Product43,
Product44,
Product45,
Product46,
Product47,
Product48,
Product49,
Product50
),
", "
)
) &
IF(
Product2,
Product2 &
IF({Product2 Quantity} > 1, "*" & {Product2 Quantity}) &
IF(
OR(
Product3,
Product4,
Product5,
Product6,
Product7,
Product8,
Product9,
Product10,
Product11,
Product12,
Product13,
Product14,
Product15,
Product16,
Product17,
Product18,
Product19,
Product20,
Product21,
Product22,
Product23,
Product24,
Product25,
Product26,
Product27,
Product28,
Product29,
Product30,
Product31,
Product32,
Product33,
Product34,
Product35,
Product36,
Product37,
Product38,
Product39,
Product40,
Product41,
Product42,
Product43,
Product44,
Product45,
Product46,
Product47,
Product48,
Product49,
Product50
),
", "
)
) &
IF(
Product3,
Product3 &
IF({Product3 Quantity} > 1, "*" & {Product3 Quantity}) &
IF(
OR(
Product4,
Product5,
Product6,
Product7,
Product8,
Product9,
Product10,
Product11,
Product12,
Product13,
Product14,
Product15,
Product16,
Product17,
Product18,
Product19,
Product20,
Product21,
Product22,
Product23,
Product24,
Product25,
Product26,
Product27,
Product28,
Product29,
Product30,
Product31,
Product32,
Product33,
Product34,
Product35,
Product36,
Product37,
Product38,
Product39,
Product40,
Product41,
Product42,
Product43,
Product44,
Product45,
Product46,
Product47,
Product48,
Product49,
Product50
),
", "
)
) &
IF(
Product4,
Product4 &
IF({Product4 Quantity} > 1, "*" & {Product4 Quantity}) &
IF(
OR(
Product5,
Product6,
Product7,
Product8,
Product9,
Product10,
Product11,
Product12,
Product13,
Product14,
Product15,
Product16,
Product17,
Product18,
Product19,
Product20,
Product21,
Product22,
Product23,
Product24,
Product25,
Product26,
Product27,
Product28,
Product29,
Product30,
Product31,
Product32,
Product33,
Product34,
Product35,
Product36,
Product37,
Product38,
Product39,
Product40,
Product41,
Product42,
Product43,
Product44,
Product45,
Product46,
Product47,
Product48,
Product49,
Product50
),
", "
)
) &
IF(
Product5,
Product5 &
IF({Product5 Quantity} > 1, "*" & {Product5 Quantity}) &
IF(
OR(
Product6,
Product7,
Product8,
Product9,
Product10,
Product11,
Product12,
Product13,
Product14,
Product15,
Product16,
Product17,
Product18,
Product19,
Product20,
Product21,
Product22,
Product23,
Product24,
Product25,
Product26,
Product27,
Product28,
Product29,
Product30,
Product31,
Product32,
Product33,
Product34,
Product35,
Product36,
Product37,
Product38,
Product39,
Product40,
Product41,
Product42,
Product43,
Product44,
Product45,
Product46,
Product47,
Product48,
Product49,
Product50
),
", "
)
) &
IF(
Product6,
Product6 &
IF({Product6 Quantity} > 1, "*" & {Product6 Quantity}) &
IF(
OR(
Product7,
Product8,
Product9,
Product10,
Product11,
Product12,
Product13,
Product14,
Product15,
Product16,
Product17,
Product18,
Product19,
Product20,
Product21,
Product22,
Product23,
Product24,
Product25,
Product26,
Product27,
Product28,
Product29,
Product30,
Product31,
Product32,
Product33,
Product34,
Product35,
Product36,
Product37,
Product38,
Product39,
Product40,
Product41,
Product42,
Product43,
Product44,
Product45,
Product46,
Product47,
Product48,
Product49,
Product50
),
", "
)
) &
IF(
Product7,
Product7 &
IF({Product7 Quantity} > 1, "*" & {Product7 Quantity}) &
IF(
OR(
Product8,
Product9,
Product10,
Product11,
Product12,
Product13,
Product14,
Product15,
Product16,
Product17,
Product18,
Product19,
Product20,
Product21,
Product22,
Product23,
Product24,
Product25,
Product26,
Product27,
Product28,
Product29,
Product30,
Product31,
Product32,
Product33,
Product34,
Product35,
Product36,
Product37,
Product38,
Product39,
Product40,
Product41,
Product42,
Product43,
Product44,
Product45,
Product46,
Product47,
Product48,
Product49,
Product50
),
", "
)
) &
IF(
Product8,
Product8 &
IF({Product8 Quantity} > 1, "*" & {Product8 Quantity}) &
IF(
OR(
Product9,
Product10,
Product11,
Product12,
Product13,
Product14,
Product15,
Product16,
Product17,
Product18,
Product19,
Product20,
Product21,
Product22,
Product23,
Product24,
Product25,
Product26,
Product27,
Product28,
Product29,
Product30,
Product31,
Product32,
Product33,
Product34,
Product35,
Product36,
Product37,
Product38,
Product39,
Product40,
Product41,
Product42,
Product43,
Product44,
Product45,
Product46,
Product47,
Product48,
Product49,
Product50
),
", "
)
) &
IF(
Product9,
Product9 &
IF({Product9 Quantity} > 1, "*" & {Product9 Quantity}) &
IF(
OR(
Product10,
Product11,
Product12,
Product13,
Product14,
Product15,
Product16,
Product17,
Product18,
Product19,
Product20,
Product21,
Product22,
Product23,
Product24,
Product25,
Product26,
Product27,
Product28,
Product29,
Product30,
Product31,
Product32,
Product33,
Product34,
Product35,
Product36,
Product37,
Product38,
Product39,
Product40,
Product41,
Product42,
Product43,
Product44,
Product45,
Product46,
Product47,
Product48,
Product49,
Product50
),
", "
)
) &
IF(
Product10,
Product10 &
IF({Product10 Quantity} > 1, "*" & {Product10 Quantity}) &
IF(
OR(
Product11,
Product12,
Product13,
Product14,
Product15,
Product16,
Product17,
Product18,
Product19,
Product20,
Product21,
Product22,
Product23,
Product24,
Product25,
Product26,
Product27,
Product28,
Product29,
Product30,
Product31,
Product32,
Product33,
Product34,
Product35,
Product36,
Product37,
Product38,
Product39,
Product40,
Product41,
Product42,
Product43,
Product44,
Product45,
Product46,
Product47,
Product48,
Product49,
Product50
),
", "
)
) &
IF(
Product11,
Product11 &
IF({Product11 Quantity} > 1, "*" & {Product11 Quantity}) &
IF(
OR(
Product12,
Product13,
Product14,
Product15,
Product16,
Product17,
Product18,
Product19,
Product20,
Product21,
Product22,
Product23,
Product24,
Product25,
Product26,
Product27,
Product28,
Product29,
Product30,
Product31,
Product32,
Product33,
Product34,
Product35,
Product36,
Product37,
Product38,
Product39,
Product40,
Product41,
Product42,
Product43,
Product44,
Product45,
Product46,
Product47,
Product48,
Product49,
Product50
),
", "
)
) &
IF(
Product12,
Product12 &
IF({Product12 Quantity} > 1, "*" & {Product12 Quantity}) &
IF(
OR(
Product13,
Product14,
Product15,
Product16,
Product17,
Product18,
Product19,
Product20,
Product21,
Product22,
Product23,
Product24,
Product25,
Product26,
Product27,
Product28,
Product29,
Product30,
Product31,
Product32,
Product33,
Product34,
Product35,
Product36,
Product37,
Product38,
Product39,
Product40,
Product41,
Product42,
Product43,
Product44,
Product45,
Product46,
Product47,
Product48,
Product49,
Product50
),
", "
)
) &
IF(
Product13,
Product13 &
IF({Product13 Quantity} > 1, "*" & {Product13 Quantity}) &
IF(
OR(
Product14,
Product15,
Product16,
Product17,
Product18,
Product19,
Product20,
Product21,
Product22,
Product23,
Product24,
Product25,
Product26,
Product27,
Product28,
Product29,
Product30,
Product31,
Product32,
Product33,
Product34,
Product35,
Product36,
Product37,
Product38,
Product39,
Product40,
Product41,
Product42,
Product43,
Product44,
Product45,
Product46,
Product47,
Product48,
Product49,
Product50
),
", "
)
) &
IF(
Product14,
Product14 &
IF({Product14 Quantity} > 1, "*" & {Product14 Quantity}) &
IF(
OR(
Product15,
Product16,
Product17,
Product18,
Product19,
Product20,
Product21,
Product22,
Product23,
Product24,
Product25,
Product26,
Product27,
Product28,
Product29,
Product30,
Product31,
Product32,
Product33,
Product34,
Product35,
Product36,
Product37,
Product38,
Product39,
Product40,
Product41,
Product42,
Product43,
Product44,
Product45,
Product46,
Product47,
Product48,
Product49,
Product50
),
", "
)
) &
IF(
Product15,
Product15 &
IF({Product15 Quantity} > 1, "*" & {Product15 Quantity}) &
IF(
OR(
Product16,
Product17,
Product18,
Product19,
Product20,
Product21,
Product22,
Product23,
Product24,
Product25,
Product26,
Product27,
Product28,
Product29,
Product30,
Product31,
Product32,
Product33,
Product34,
Product35,
Product36,
Product37,
Product38,
Product39,
Product40,
Product41,
Product42,
Product43,
Product44,
Product45,
Product46,
Product47,
Product48,
Product49,
Product50
),
", "
)
) &
IF(
Product16,
Product16 &
IF({Product16 Quantity} > 1, "*" & {Product16 Quantity}) &
IF(
OR(
Product17,
Product18,
Product19,
Product20,
Product21,
Product22,
Product23,
Product24,
Product25,
Product26,
Product27,
Product28,
Product29,
Product30,
Product31,
Product32,
Product33,
Product34,
Product35,
Product36,
Product37,
Product38,
Product39,
Product40,
Product41,
Product42,
Product43,
Product44,
Product45,
Product46,
Product47,
Product48,
Product49,
Product50
),
", "
)
) &
IF(
Product17,
Product17 &
IF({Product17 Quantity} > 1, "*" & {Product17 Quantity}) &
IF(
OR(
Product18,
Product19,
Product20,
Product21,
Product22,
Product23,
Product24,
Product25,
Product26,
Product27,
Product28,
Product29,
Product30,
Product31,
Product32,
Product33,
Product34,
Product35,
Product36,
Product37,
Product38,
Product39,
Product40,
Product41,
Product42,
Product43,
Product44,
Product45,
Product46,
Product47,
Product48,
Product49,
Product50
),
", "
)
) &
IF(
Product18,
Product18 &
IF({Product18 Quantity} > 1, "*" & {Product18 Quantity}) &
IF(
OR(
Product19,
Product20,
Product21,
Product22,
Product23,
Product24,
Product25,
Product26,
Product27,
Product28,
Product29,
Product30,
Product31,
Product32,
Product33,
Product34,
Product35,
Product36,
Product37,
Product38,
Product39,
Product40,
Product41,
Product42,
Product43,
Product44,
Product45,
Product46,
Product47,
Product48,
Product49,
Product50
),
", "
)
) &
IF(
Product19,
Product19 &
IF({Product19 Quantity} > 1, "*" & {Product19 Quantity}) &
IF(
OR(
Product20,
Product21,
Product22,
Product23,
Product24,
Product25,
Product26,
Product27,
Product28,
Product29,
Product30,
Product31,
Product32,
Product33,
Product34,
Product35,
Product36,
Product37,
Product38,
Product39,
Product40,
Product41,
Product42,
Product43,
Product44,
Product45,
Product46,
Product47,
Product48,
Product49,
Product50
),
", "
)
) &
IF(
Product20,
Product20 &
IF({Product20 Quantity} > 1, "*" & {Product20 Quantity}) &
IF(
OR(
Product21,
Product22,
Product23,
Product24,
Product25,
Product26,
Product27,
Product28,
Product29,
Product30,
Product31,
Product32,
Product33,
Product34,
Product35,
Product36,
Product37,
Product38,
Product39,
Product40,
Product41,
Product42,
Product43,
Product44,
Product45,
Product46,
Product47,
Product48,
Product49,
Product50
),
", "
)
) &
IF(
Product21,
Product21 &
IF({Product21 Quantity} > 1, "*" & {Product21 Quantity}) &
IF(
OR(
Product22,
Product23,
Product24,
Product25,
Product26,
Product27,
Product28,
Product29,
Product30,
Product31,
Product32,
Product33,
Product34,
Product35,
Product36,
Product37,
Product38,
Product39,
Product40,
Product41,
Product42,
Product43,
Product44,
Product45,
Product46,
Product47,
Product48,
Product49,
Product50
),
", "
)
) &
IF(
Product22,
Product22 &
IF({Product22 Quantity} > 1, "*" & {Product22 Quantity}) &
IF(
OR(
Product23,
Product24,
Product25,
Product26,
Product27,
Product28,
Product29,
Product30,
Product31,
Product32,
Product33,
Product34,
Product35,
Product36,
Product37,
Product38,
Product39,
Product40,
Product41,
Product42,
Product43,
Product44,
Product45,
Product46,
Product47,
Product48,
Product49,
Product50
),
", "
)
) &
IF(
Product23,
Product23 &
IF({Product23 Quantity} > 1, "*" & {Product23 Quantity}) &
IF(
OR(
Product24,
Product25,
Product26,
Product27,
Product28,
Product29,
Product30,
Product31,
Product32,
Product33,
Product34,
Product35,
Product36,
Product37,
Product38,
Product39,
Product40,
Product41,
Product42,
Product43,
Product44,
Product45,
Product46,
Product47,
Product48,
Product49,
Product50
),
", "
)
) &
IF(
Product24,
Product24 &
IF({Product24 Quantity} > 1, "*" & {Product24 Quantity}) &
IF(
OR(
Product25,
Product26,
Product27,
Product28,
Product29,
Product30,
Product31,
Product32,
Product33,
Product34,
Product35,
Product36,
Product37,
Product38,
Product39,
Product40,
Product41,
Product42,
Product43,
Product44,
Product45,
Product46,
Product47,
Product48,
Product49,
Product50
),
", "
)
) &