How I find the first column?


I have a range of columns with 14 milestones.

If the milestone reached, then it will be delete and the cell is blank.

Now I would know, in which column are the first date. As result I would need the column-name, with the first date or the number of column, counted from the first column of the range.

Any ideas, which formula I can use for it?!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!