I need help with a IF formula with a check box

I want to create a report of all my orders that are ordered AND verbally confirmed, but when an order is only verbally confirmed I want a star to be next to the order.

I have a date column that notes a verbal confirmation. I also have a date column that notes an order date.

I want the check box to check IF there is a verbal confirmation but not order, and uncheck once there is an order date. I cannot figure out the right IF formula to make this work.

Find more posts tagged with

Formulas

Accepted answers

Javed Hassan

Hi There!

Give this a try:

=IF(AND(NOT(ISBLANK([Verbally Confirmed]@row)), ISBLANK([Order Date]@row)), 1, 0)

StefanieM

That is perfect. Thank you!

All comments

Javed Hassan

Hi There!

Give this a try:

=IF(AND(NOT(ISBLANK([Verbally Confirmed]@row)), ISBLANK([Order Date]@row)), 1, 0)

StefanieM

That is perfect. Thank you!

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.