What is smartsheet's equivalency of "*"&Ryan&"*"?

Abbie G

I'm trying to write a formula that finds all cells that have Ryan in it. What is the equivalency of the above in smartsheet form?

Andrée Starå

Hi @Abbie G

I hope you're well and safe!

You'd use CONTAINS for that.

https://help.smartsheet.com/function/contains

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 support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Abbie G

I hope you're well and safe!

You'd use CONTAINS for that.

https://help.smartsheet.com/function/contains

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 support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Abbie G

Thank you @Andrée Starå !!

Andrée Starå

@Abbie G

You're more than welcome!