5

 

Hello,

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.

 

Functionality
Industry

Comments

I couldn't make it work. Where do I add IFERROR to the formula below?

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