Remove the "0" in the column formula cell.


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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!