IF & ISBlank Function
I am trying to test whether or not the score inputted is greater than 80 or less than 80.
If the score is greater than 80 , I would like my status column to populate with a string labeled "Passed".
If the score is less than 80 I would like my status column to populate with a string labeled "Failed".
Heres the issue, I am unable to account for blank columns. My hope is to nest the ISBLANK function inside of the if statement, to prevent the function from reading blank cells as a "Failed".
Is this possible?
See image & function I am currently using below:
=IF(Score2 < 80, "Failed", "Passed")
Comments
-
Hi
You could try:
=IF(ISBLANK(Score2), "", IF(Score2 < 80, "Failed", "Passed"))
Worked for me
Kind regards
Debbie Sawyer Consultant & Training Manager
-
Try this nested IF statement that checks for blank scores and keeps the field blank. I also updated your formula to work in any row.
=IF(ISBLANK(Score@row), "", IF(Score@row < 80, "Failed", "Passed"))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!