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.
Help Article Resources
Check out the Formula Handbook template!