Networkdays when second date is empty

Options
Angie Hatfield
Angie Hatfield ✭✭✭✭
edited 12/09/19 in Smartsheet Basics

I'm trying to figure out how to get the network days when the second date column is blank. It should then just be 1.

I'm going crazy trying to figure it out.

 

Update: I am still playing with this formula. I've realized I just need an IFBlank formula. If blank, return 1.

My formula  returns #Incorrect argument set

=IF(ISBLANK([PTO Date]4, "1"))

=IF(ISBLANK([PTO Date]4, 1))

=ISBLANK([PTO Date]4, "1")

=ISBLANK([PTO Date]4, 1)

 

 

Comments