Making a Date Column N/A unless needed to for a specific row

justin46491

I was wondering if there is a way to make a date column go N/A unless needed for a specific row or rows.  

 

For Example:

 

I only want the Delivery Date Column to be active when it comes to Deliveries.  Is there a way to do this or no?

 

Please Help

 

Thank You.

L_123

=if([column2]1="Delivery",[date reference],"N/A")