Hello,
My index match formula cross sheet is giving error since yesterday.
=INDEX({VER DT4DT Tools Range 1}, MATCH([App CI]@row , {VER DT4DT Tools Range 2}, 0))
I have checked the format of columns in both sheet and also retyped formula. any advice?
Hey @stuti.bhagwati,
Have you tried the AI Generate Formulas on the right side tool bar? It's been able to fix formula issues when Iv'e stared at number too long and can't figure out my issue.
There is a space in between [[ @row , {VER ]]. I think SmartSheet would fix that once you've entered it into a cell, but I thought I'd mention it just in case.
Could you provide what the data looks like? Those might help better replicate what you're trying to accomplist. Thanks!
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.
