ISNA transfer excel formula to smartsheet

Options

I am trying to create a template in Smartsheet that was housed in excel.  There is a bit of a complicated formula I am trying to transfer and having a heck of a time.   Here is the excel formula:

=IF(ISNA(MATCH(5,'Project Assessment'!G6:G22,0)),IF(ISNA(MATCH("High Risk",D8:D10,0)),IF(B11>935,IF(ISNA(MATCH(5,'Project Assessment'!G20,0)),"High Risk","Very High Risk"),IF(B11>310,"Medium Risk","Low Risk")),IF(ISNA(MATCH(5,'Project Assessment'!G20,0)),"High Risk","Very High Risk")),IF(ISNA(MATCH(5,'Project Assessment'!G20,0)),"High Risk","Very High Risk"))   

I know I have to change the data locations ('Project Assessment!G6:G22 and D8:D10 and B11 and 'Project Assessment'!G20), however since the ISNA does not exist in Smartsheet not sure what to replace it with.

I did not create the original formula and am not even certain why the ISNA is being used.   Any suggestions?

Terry

 

 

 

Comments