True/False formula?
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
-
@Jillian M an IF statement will do what you need.
=if([Column Name]@row="Value",1,0)
Answers
-
@Jillian M an IF statement will do what you need.
=if([Column Name]@row="Value",1,0)
-
Amazing! Thank you for being so quick to respond. #learnsomethingneweveryday
-
@JamesB Now I need a similar formula to state if a cell is "4" or greater to state "Pass", if 3 or less, then "Fail". Suggestions?
Nevermind :-) I figured it out! :-)
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives