Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

IF() Statement troubles

Shelly Long
edited 12/09/19 in Archived 2016 Posts

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?



This discussion has been closed.