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.

Best Answer

  • Anjanesh Vaidya
    Anjanesh Vaidya ✭✭✭✭✭
    Answer ✓
    Options

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!