do not run formula if cell is blank

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.

Find more posts tagged with

Education

Formulas

Hi,

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

Did it work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

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

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

Try this.

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

Did it work?

It worked! Thank you so much!

Excellent!

Happy to help!

Dropdown list restrictions
Is there a way to limit a dropdown list so that the values in the dropdown list can only be used once in a column?
seeking VLOOKUP or equivalent, search for most recent value, multiple dropdowns
My product/use case: I seek to build a camera inventory. Each camera has a unique identifier. Cameras are mobilized to different locations on different days. I need help making a VLOOKUP or equivalent combination of formulae functions to run 2 queries cross-referencing 2 grids, searching a column with multiple dropdown…
Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet