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!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!