ISBLANK Nesting

Bluenose
Bluenose
edited 12/09/19 in Formulas and Functions

Good Morning All, 

I am new to Smartsheets and would like some assistance on what I thought would be straight forward and I know I am missing something basic.

So the formula in English:

Is DATE 2 Blank 

YES - then NETDAYS between DATE 1 and TODAY in DAYS

NO -  the NETDAYS between DATE 1 and DATE 2 in DAYS

 

So I thought it would be written as:

IF(ISBLANK([DATE 2]1), (NETDAYS([DATE1]1, TODAY()), (NETDAYS([DATE 1]1),([DATE 2]1))) 

All I get is Unparseable, why is my logic failing, it seems like it has continuity, but obviously not.  Any help would be great appreciated.

 

Blue

 

 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!