using if functions to perform multiple logical evaluations

I am needing to look at one cell to see if it has a specific word and then if it does use networkdays to calculate using two other cells.  I am able to do this in excel, but unable to find the correct formula to do in smartsheet.  Below is an example of what I used in creating it in excel.


In smart sheet I the column name for (A2) in my excel example is Application.  I need to know how many networdays it is taking from one stage to another.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!