ISNA transfer excel formula to smartsheet

terry.romanishen35591

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

 

 

 

Mike Wilday

Have you considered ISERROR? 

More on the ISERROR function

See this post for a discussion on using Iserror instead of ISNA with an IF formula. 

terry.romanishen35591

I had not tried ISERROR and just did.  It worked perfectly!  I sincerely appreciate your assistance. Take Care

Terry