Trigger "Yes, No, Hold" on item returned.

Hello, I'm still learning SS formulas, and could use some help on what is probably a very "Smartsheet 101" situation.

I have a "Item Returned" column that contains a date the item was returned, I would like the yes or no flag to come up on the next column to visually signal if it was returned. I figure a formula like =IF(blank(Item Returned)YES) is how this would start out and of course am getting an "unparseable" error.

Any help is appreciated!

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Try something more like this:

=IF([Column Name]@row = "", "No", "Yes")

If the column on this row is blank, then output "No", otherwise "

All comments

Paul Newcome

Try something more like this:

=IF([Column Name]@row = "", "No", "Yes")

If the column on this row is blank, then output "No", otherwise "

Mike_T

Thanks Paul! That's exactly what I needed!

Paul Newcome

Happy to help. 👍️

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.