Lookup value in next blank row (W/Reference Another Sheet)

We are trying to auto-number rows once we have an approval completed. We cannot use the auto-number function, as the owner would like to keep the numbering order as the order they were approved. The sheet is grouped into different categories, making it so the lines are not in order of when they will be approved.

I created a helper sheet, and would like to bring back the row number of the next blank row, however I am getting an #INCORRECT ARGUMENT SET error. I know I am missing something in my formula, but have been looking at it way too long and am stuck.

=IF(ISBLANK({Test Sheet PO Numbers Range 1}), {Test Sheet PO Numbers Range 2}, "")

Find more posts tagged with

Formulas

Accepted answers

Jason Tarpinian

What if you created a helper sheet where you could trigger an automation on your main sheet to copy row over when "Approval Completed". You could then do a MATCH() from your main sheet to the helper sheet to return the row number of said task? Or you could auto-number on the helper sheet to start off whatever number would make sense and then do an INDEX/MATCH off of that?

All comments

Jason Tarpinian

Melissa Evanochko

Thank you! This worked perfectly. I had started to get there, but got hung up. I very much appreciate your response!

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.