Jamison’s Profile

Community member since June 2015

points
810

6

Hi, I have a question regarding using formulas and drop down menus.

 

Similar to an FMEA, I want to have dropdown menus (High, Med, Low) for the severity, occurrance and detectibility. Then I want to have a formula that produeces a RPN (Risk Priority Number) by assigning the value 10 to High, 7 to

4

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