How to create formulas comparing two columns with multiple criteria

Options

I need a formula, If Closed Date column is blank, any values in Status column should retrieve blank value in Result column. If Closed Date has a date and status column has “Reopened” value then it should retrieve blank value in Result column. However, if Closed Date has a date and status column has value other than “Reopened”  then it should retrieve “N/A” value in Result column.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!