Remove the "0" in the column formula cell.
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.
Help Article Resources
Check out the Formula Handbook template!