Another If Formula

Question

=IF(NOT(ISBLANK([Payment Type]@row)),CONCATENATE([Payment Type]@row,"-",TEXT([Invoice Date]@row,"MM/DD/YY"),"-PD-",TEXT([Posted Date]@row,"MM/DD/YY")),"")

I cant figure out whats wrong with this formula. The column names all work and are named appropriately

AdamApexConsultants · Accepted Answer

=IF(NOT(ISBLANK([Payment Type]@row)), [Payment Type]@row + "-" + [Invoice Date]@row + "-PD-" + [Posted Date]@row, "") * [Payment Type]@row + "-":* Combines the value of [Payment Type]@row with a hyphen. * [Invoice Date]@row:* Includes the invoice date directly, using the sheet's default date format. * "-PD-" + [Posted Date]@row:* Adds the prefix -PD- before including the posted date.