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?!

Find more posts tagged with

Project Management

Accepted answers

Paul Newcome

Try something like this to output the number

=MATCH(INDEX(COLLECT([1st Column]@row:[Last Column]@row, [1st Column]@row:[Last Column]@row, @cell <> ""), 1, 1), [1st Column]@row:[Last Column]@row, 0)

All comments

Paul Newcome

Try something like this to output the number

=MATCH(INDEX(COLLECT([1st Column]@row:[Last Column]@row, [1st Column]@row:[Last Column]@row, @cell <> ""), 1, 1), [1st Column]@row:[Last Column]@row, 0)

NWenzel

Hi Paul - many thanks! It works, perfect!!!

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.