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
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?
Comments
-
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
-
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.
-
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)))
-
That worked. Thank you!!!
Categories
- All Categories
- 14 Welcome to the Community
- 10.6K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
