Remove the "0" in the column formula cell.

Kayla

Help please!

I am trying to put the item name (column name) in a cell if it's listed as "Complete". This is working for the most part, but if none of my IF criteria matches, it shows a "0" in the cell or if only the last column meets the criteria, it shows a "0" for the first column.

See formula in Screenshot and the cells where "0" is showing are highlighted yellow.

Zero in IF formula cell.png

Christopher Pretty

Hi Kayla,

Try using this formula

=IF(One@row = "Complete", CHAR(10) + "One", "") + IF(Two@row = "Complete", CHAR(10) + "Two", "") + IF(Three@row = "Complete", CHAR(10) + "Three", "")

Christopher Pretty

Hi Kayla,

Try using this formula

=IF(One@row = "Complete", CHAR(10) + "One", "") + IF(Two@row = "Complete", CHAR(10) + "Two", "") + IF(Three@row = "Complete", CHAR(10) + "Three", "")

Kayla

@Christopher Pretty - It worked!! I knew it would be something so simple and right in front of me. THANK YOU!