Need help to modify the given formula.

Hi,

I and trying to write following formula where first it is checking the row ID and then matching content in the other column in the same row and returning the incremental value, but it is throwing #INCORRECT ARGUMENT SET error.

=IF({WorkOrder#} >= 1, INDEX("TD"), MATCH(({WorkOrder#} >= 1), {WorkOrder#}), 0)

Prajna

Find more posts tagged with

Accepted answers

All comments

Genevieve P.

Hi @Prajna Jain

I answered your other post that had a similar question (see here). Is this the same formula? Did either of my suggestions work?

With cross-sheet formulas you won't be able to use an IF statement directly like this. You most likely will want to use an INDEX(COLLECT if you have 2 criteria to search for, like so:

=INDEX(COLLECT({range to pull from}, {first criteria range}, first criteria, {second criteria range}, second criteria), 1)

Does that make sense? Let me know if you need further direction on either post.

Cheers,

Genevieve

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.