Min Function is ignoring the blank cells

Hi,

I understand that min function will ignore cells that are blank between two columns. I am wondering I will I be able to still ouput the data between two columns with one column showing data and the other not.

Here is my formula

=IF([Request Status]@row = "Approved", MIN([SQA Exception Due Date]@row, [QS Exception Due Date]@row))

If the request status is approved please return the min date from these two separate columns.

Thank you for your help

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Have you tested it?

Jamil James

I tested it and it worked for another sheet. Unfortunately it would not work for sheet that is in production.

Paul Newcome

Ok. So what are the differences between the two sheets?

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.