How to return a blank entry if column contains no data
Hi! I'm new(ish) to Smartsheet and am struggling with what I believe is a simple formula.
I have a simple rating column in an existing sheet with a 1-5 ranking (1 being low, 5 being high). If the rating is 1, I want my "re-hire" column to spit back a "NO" entry. If it's greater than 1, I wanted it to spit back a "YES" entry. And if it's blank, I want the cell to remain blank.
I've figured out the first chunk of the formula, but I am struggling with how to incorporate a blank entry.
Here's what I have so far:
=IF(([PRODUCER RATING]@row < 2), "NO", "YES")
I'm unsure if I need to incorporate the IFAND, IFOR, IFERROR, IFBLANK... or something else entirely.
Thanks in advance for the help.
Best Answer
-
Hi Andrew Ryback,
As per your condition, you can try the below formula:
=IF(Rating@row = 1, "NO", IF(Rating@row > 1, "YES", " "))
I hope it will work!
Thank You!
Anjanesh Vaidya
Thanks,
Anjanesh Vaidya
Smartsheet Development, Ignatiuz Software
Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️
Answers
-
Hi Andrew Ryback,
As per your condition, you can try the below formula:
=IF(Rating@row = 1, "NO", IF(Rating@row > 1, "YES", " "))
I hope it will work!
Thank You!
Anjanesh Vaidya
Thanks,
Anjanesh Vaidya
Smartsheet Development, Ignatiuz Software
Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️
-
I hope you're well and safe!
Try something like this.
=IF([PRODUCER RATING]@row <> "", IF([PRODUCER RATING]@row > 1, "YES", "NO"))
Did that work/help?
I hope that helps!
Have a fantastic week & Happy Holidays!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thank you! This worked. Appreciate the help.
-
Excellent!
Happy to help!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 382 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!