tryin to if function with OR and AND

MazU

Hi All,

If there is a date in 'date found' column and date in 'Date collected' column, Column7=Collected

if there is a date in 'date found' column but no date 'Date collected' column, column 7=Uncollected

if the 'Date found' column is blank, column7=blank

Can anyone please try help

@Genevieve P.

@Paul Newcome

can you please assist me, i would appreciate it a lot

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Try something like this:

=IF([Date Found]@row <> "", IF([Date Collected]@row <> "", "Collected", "Uncollected"))

MazU

@Paul Newcome

Thank you Paul, really appreciate your response.

I actually managed to do using a different formula but yours is way more simpler

=IF(ISBLANK([Date Found]@row), "", IF(AND(ISDATE([Date Found]@row), ISDATE([Date Collected]@row)), "Collected", "Not Collected"))

Thanks once again

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.