Can someone help with this formula

stuti.bhagwati

We are trying to read 4 columns and combine to get Status. It works in excel but not in smartsheet.

=IF(ISNUMBER(SEARCH("Other",[Sys_Class]@row)), "Others",IF(ISNUMBER(SEARCH("NO MATCH",[operational_status]@row)), "Completed",IF(ISNUMBER(SEARCH("Vernova Infra L2",[support_group]@row)), "Completed",IF([Planned Date of Exit]@row<TODAY(),"At Risk","On Track"))))

SteveAtPathtoSummit

Looks to be structured properly, but something to consider would be to make sure the Planned Date of Exit column is a date format. Also, if any of the cells referenced are empty, it may cause issues too.