=IF formula question
Hi,
I wanted to use a formula to input a Pass or Fail dependent on if one of the columns to the left of the score showed a f. If any of those columns show an f it would need to read Fail. Help?
Best Answer
-
Instead of highlighting the entire column, you'll want your range to go from the very far left cell in this row to the closest right cell in this row. So, this would be your range:
[Medical Necessity]@row:[Collection Plan]@row
I would also use a COUNTIF Function to COUNT the number of cells that say either "F" or "Fail" depending on how you'll set this up. Then if the COUNT is greater than 0, return "Fail".
Try something like this:
=IF(COUNTIF([Medical Necessity]@row:[Collection Plan]@row, "Fail") > 0, "Fail", "Pass")
Cheers!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Use CONTAINS function - CONTAINS Function | Smartsheet Learning Center
-
Ok, i think thats the right direction Anupriya but im still stuck lol because i cant select the columns.
-
Instead of highlighting the entire column, you'll want your range to go from the very far left cell in this row to the closest right cell in this row. So, this would be your range:
[Medical Necessity]@row:[Collection Plan]@row
I would also use a COUNTIF Function to COUNT the number of cells that say either "F" or "Fail" depending on how you'll set this up. Then if the COUNT is greater than 0, return "Fail".
Try something like this:
=IF(COUNTIF([Medical Necessity]@row:[Collection Plan]@row, "Fail") > 0, "Fail", "Pass")
Cheers!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!