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.


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!