Having trouble with IF "CONTAINS" function

Hello,

I have a column with a dropdown list that allows users to select Yes or No to satisfy the requirements of a question. If the user choses “Yes” they are then required to provide details to explain their answer. To eliminate blank cells on the sheet where the answers are recorded, I used the following formula to return the result:  =IF(CONTAINS("No", [Site related delays:]@row), "N/A", " ")

The formula works if the user choses “No” however, if the user chooses ‘Yes” and provides details as required the cell isn’t return the user input data(text) it is only showing blank. How do I correct this?

Formula:

=IF(CONTAINS("No", [Site related delays:]@row), "N/A", " ")

 

Thank you,

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!