Guys, Smartsheet is returning #INVALID REF after transforming the column to column form. The formula is simple: = INDEX ({Standard Tasks Reg. - 2021 - BASE AME Interval 1}; MATCH (Reference @ row; {Standard Tasks Reg. - 2021 - BASE AME Interval 2})) or = VLOOKUP (Reference @ row; {Standard Tasks Reg, - 2021 - BASE AME Interval 3}; 8; 0) Observation: The sheets contains 5000 rows. Can you tell me what could be happening? Thanks. * Photo of the form inside the cell. * Photo as clumn form

INDEX-MATCH or VLOOKUP returns #INVALID REF when in COLUMN FORM

Guys, Smartsheet is returning #INVALID REF after transforming the column to column form.

The formula is simple:

= INDEX ({Standard Tasks Reg. - 2021 - BASE AME Interval 1}; MATCH (Reference @ row; {Standard Tasks Reg. - 2021 - BASE AME Interval 2}))

= VLOOKUP (Reference @ row; {Standard Tasks Reg, - 2021 - BASE AME Interval 3}; 8; 0)

Observation: The sheets contains 5000 rows.

Can you tell me what could be happening?

Thanks.

Photo of the form inside the cell.

Photo as clumn form

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Are there any rows at all that do not contain data or contains an error in the Reference column?

Arthur Magalhães

Paul, the last 20 rows do not contain data and are there no errors in the Reference Column.

Andrée Starå

Hi @Arthur Magalhães

I hope you're well and safe!

Have you checked the reference manager? What does it say?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Arthur Magalhães

Hi Andrée,

It is this way -> Status: In Process.

But, it's been like this for 2 days. I thought it might be a delight due to some overhead, but it hasn't changed after this time.

Be safe and have a fantastic weekend too!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.