Having trouble with IF "CONTAINS" function
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?
=IF(CONTAINS("No", [Site related delays:]@row), "N/A", " ")
Help Article Resources
Check out the Formula Handbook template!