Formula help

Options

Hi all,

how do I write a formula in smart sheets to only consider text that is on the left of the equal sign

Location = Belgium

Thanks Tom

• ✭✭✭✭✭✭
Options

My apologies. I thought you only wanted the left. Here is a formula for the right portion:

=RIGHT([Column name]@row, LEN([Column Name]@row) - (FIND("=", [Column Name]@row) + 1))

• ✭✭✭✭✭✭
Options

You would use something like this:

=LEFT([Column Name]@row, FIND("=", [Column name]@row) - 1)

• ✭✭✭✭✭✭
Options

I hope you're well and safe!

Do you only want to show the information on the left side in a separate cell?

Be safe, and have a fantastic week!

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!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

Hi Andree, its the Right side i am looking for,

The length text to the = sign is constant, to the right side its variable

I modified Paul but it doesn't give me a constant value

Tom

=RIGHT([Column Name]@row, FIND("=", [Column name]@row) – 0)

= Belgium

= Belgium

n = Brazil

n = Brazil

n = Brazil

on = Chile

on = Chile

h Republic

= Denmark

= Finland

= Finland

= France

= France

Bangalore

• ✭✭✭✭✭✭
Options

My apologies. I thought you only wanted the left. Here is a formula for the right portion:

=RIGHT([Column name]@row, LEN([Column Name]@row) - (FIND("=", [Column Name]@row) + 1))

• Options

super that worked @Paul Newcome thanks!

• ✭✭✭✭✭✭
Options

Let me know if I can help with anything else!

Best,

Andrée

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

hI Andree, now that i have calendars sorted i want to create an alert when a holiday occurs within the next 45 days

below is not working for me

Tom

=IF((NETDAYS(TODAY(), Start@row) < 45, "True", "False")

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

Try removing one of the open parenthesis after the IF function.

• Options

worked great @Paul Newcome ! thanks

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!