How to return a blank entry if column contains no data

Options

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.

• ✭✭✭✭✭
Options

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

• ✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

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.

• Options

Thank you! This worked. Appreciate the help.

• ✭✭✭✭✭✭
Options

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!