I need help with a IF formula with a check box

StefanieM

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.

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!

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!