do not run formula if cell is blank

Nancy Skoulphong

 

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.

 

Andrée Starå

Hi,

You'd use an IFERROR function in the start of the formula. 

More info: https://help.smartsheet.com/function/iferror

Did it work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Nancy Skoulphong

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

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

Andrée Starå

Try this.

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

Did it work?

Nancy Skoulphong

It worked! Thank you so much!

Andrée Starå

Excellent!

Happy to help!