do not run formula if cell is blank

Nancy Skoulphong
Nancy Skoulphong ✭✭✭✭
edited 12/09/19 in Formulas and Functions



I am a new Smartsheet user. I have search some previous inquiries on this topic and tried the suggestions but I cannot seem to get it right. 

What do I need to add so the formula will not run if the check-in and check-out dates are blank?

=NETDAYS([Check-In]1, [Check-Out]1 - 1)

Thank you so much for your help.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!