True/False formula?

Options
Jillian M
Jillian M ✭✭
edited 07/21/23 in Smartsheet Basics

I'm trying to figure out a formula to note a "1" in the cell if the information in the cell next to it is a certain value, any other value needs to show a "0". Is this a "true/false" formula?

I figured this out: =IF([Question 1]@row = "2. I should avoid using the electronic device during the initial connection; however, should use the device to log the information discussed prior to leaving the patient's room", 1, "1") however when copying the formula to additional cells, it's showing the "1" for everything instead of those that only show the desired information. I"m missing the 2nd part...thanks!

Best Answer

Answers