MAX with VALUE and LEFT

Baker VDC

=MAX(VALUE(LEFT({OTHER SHEET REFERENCE RANGE}, 4)))

I'm trying to first get TEXT/NUMBER column to read first 4 characters (i.e. 0004-1 to be 0004),

Then trying to get TEXT to NUMBER conversion (i.e. 0004 to 4),

Then trying to get MAX out of that adjusted range.

Getting INVALID DATA TYPE.

Find more posts tagged with

Accepted answers

Leibel S

@Baker VDC

You would need to add a column in the 'OTHER SHEET' with the =VALUE(LEFT([Column name]@row,4))

then make that your cross sheet reference and put it directly into the MAX function

All comments

Leibel S

@Baker VDC

You would need to add a column in the 'OTHER SHEET' with the =VALUE(LEFT([Column name]@row,4))

then make that your cross sheet reference and put it directly into the MAX function

Baker VDC

Dang, I was trying to avoid a helper column, but I guess that makes sense.

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.