IF() Statement troubles

Shelly Long

In Excel I can use the following statement with no issue:  =IF(A89="","",(WORKDAY(A89,-3,Holidays!$A$2:$A$9)))

 

I tried the following in Smartsheet and receive the error:  #BLOCKED.  =IF([Launch Date]36 = "", "", (WORKDAY([To Production by 3 pm (Site merch deadline)]36, -1, $[Holidays 2016]$1:$[Holidays 2017]$13)))

 

Any suggestions?

Jamison

You can't refer to another sheet for a formula in Smartsheet (which i think you are doiing - assuming that "Holidays 2016" is a separate sheet).

 

http://help.smartsheet.com/customer/en/portal/articles/775363-using-formulas#faq

Shelly Long

Holidays are actually just columns in the current Smartsheet.  In Excel it is on another sheet but not my Smartsheet.  The Holiday part is actually working correctly.  What is not working is the IF reference.  =IF([Launch Date]36 = "", "",   When I remove that section the formula is fine.

Jamison

Ah - my mistake.

 

Looks like you are checking if a cell is blank and if it is blank, leave it alone (blank), if it isn't blank, return the Workday function value.

 

If that is correct, try this:

 

=IF(ISBLANK([Launch Date]36), "", (WORKDAY([To Production by 3 pm (Site merch deadline)]36, -1, $[Holidays 2016]$1:$[Holidays 2017]$13)))

 

 

 

 

Shelly Long

That worked.  Thank you!!!