IF/OR Formula issue

Hi,

I'm trying to pull data from another sheet if the date meets the criteria in one of two columns of 12/20/2025. Should I use an if/or or nested ifs? Here is what I have so far but get the #INCORRECT ARGUMENT SET error. Here's what I have so far. Any idea what I'm doing wrong?

=IF(OR(INDEX({cutdate}, MATCH([Job ID]@row , {schedjb}, 0)) = DATE(2025, 12, 20), (INDEX({changedate}, MATCH([Job ID]@row , {schedjb}, 0)) = DATE(2025, 12, 20)), INDEX({requestdate}, MATCH([Job ID]@row , {schedjb}, 0)), ""))

Thanks

Find more posts tagged with

Formulas

Accepted answers

Jim08

I got it, this is what ended up working for me. Thanks for your help!

=IF(COUNT(COLLECT({requestdate}, {schedjb}, [Job ID]@row , {cutdate}, DATE(2025, 12, 20))) > 0, INDEX(COLLECT({requestdate}, {schedjb}, [Job ID]@row , {cutdate}, DATE(2025, 12, 20)), 1), IF(COUNT(COLLECT({requestdate}, {schedjb}, [Job ID]@row , {changedate}, DATE(2025, 12, 20))) > 0, INDEX(COLLECT({requestdate}, {schedjb}, [Job ID]@row , {changedate}, DATE(2025, 12, 20)), 1), ""))

All comments

Paul Newcome

Try this:

=IF(OR(IFERROR(INDEX({cutdate}, MATCH([Job ID]@row, {schedjb}, 0)), "") = DATE(2025, 12, 20), IFERROR(INDEX({changedate}, MATCH([Job ID]@row, {schedjb}, 0)), "") = DATE(2025, 12, 20)), INDEX({requestdate}, MATCH([Job ID]@row, {schedjb}, 0)), ""))

Jim08

https://community.smartsheet.com/discussion/comment/494412#Comment_494412

No luck. It gives me a blank but I know 95% of these has a 12/20/25 date in either schedjb or changedate on the other sheet.

Paul Newcome

Are you able to provide some screenshots for context?

Jim08

I got it, this is what ended up working for me. Thanks for your help!

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.