Managers Approval Matrix > Pull Which Level Manager is Needed + Skip to Next Level Manager if Blank

Hi All!

I have manager level. I need to pull in the Employee ID (EID) for the Manager Level of Approver that each requires. And if it's blank I need to pull the next level approver.

In the picture below, the two green circles highlight this. So if a contract value determines I need a Level 4 approver (already setup separately) in the top green circle and there's no level 4, I need to populate with Level 5.

I have this so far, but I feel like I'm way off & I can't get it to function.

=IF([Which level Manager is needed? (hidden)]@row = [Level 1]1:[Level 7]1, [Level 1]@row:[Level 7]@row, "")

Thank you!!!!

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

What exactly is in that column that outputs which level is needed? Is that accurate?

If so, you should be able to use:

=INDEX([Level 1]@row:[Level 7]@row, [Which level Manager is needed? (hidden)]@row)

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.