Formula help

Thomas Bolger

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

Paul Newcome

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))

Paul Newcome

You would use something like this:

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

Andrée Starå

Hi @Thomas Bolger

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!

Thomas Bolger

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

Paul Newcome

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))

Thomas Bolger

super that worked @Paul Newcome thanks!

Andrée Starå

@Thomas Bolger

I saw that Paul had answered already!

Let me know if I can help with anything else!

Best,

Andrée

Thomas Bolger

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")

Paul Newcome

Happy to help. 👍️

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

Thomas Bolger

worked great @Paul Newcome ! thanks