Good afternoon Smartsheet!
Looking for assistance to making this work.
Let's say I have a check box column for "Contains Potatoes"
I need this box to automatically check if the column for "Entree Sides" contains the word "Potato".
Thanks!
Hi @Nancy Heater
I hope you're well and safe!
Try something like this.
=CONTAINS("Potato", [Entree Sides]@row)
Did that work/help?
I hope that helps!
Be safe and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
@Andrée LaRivière ... perfect. I knew I was way over thinking it!
Thank you, and have a great weekend!
@Nancy Heater
Excellent!
You're more than welcome!
@Andrée Starå@Andrée Starå Expanding on this... how would you adjust your formula if the tick box column wasn't limited to potatoes and you wanted to tick a box if, say, carrots or beets were also Entree Sides?
I was thinking something like...
=IF(OR(CONTAINS("potato", "carrot", "beet"), [Entree Sides]@row]), 1)
...but can't get this to work.
Hi! If I want to create a single checkbox column next to a multi checkbox column that will automatically checkmark if the multi checkbox column has "new" check marked, how do I do that?
Hi @Smartsheetuser71
Try something like this:
=IF(HAS([Multi Checkbox]@row, "New"), 1, 0)
Cheers,
Genevieve
Thanks.
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.
