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.

Find more posts tagged with

Accepted answers

Anjanesh Vaidya

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

All comments

Anjanesh Vaidya

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

Andrée Starå

Hi @Andrew Ryback

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!

Andrew Ryback

Thank you! This worked. Appreciate the help.

Andrée Starå

@Andrew Ryback

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.