Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Finding Formula

Topic Labels: Formulas
Solved
Jump to Solution
1250 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Sam_Greenberg
5 - Automation Enthusiast
5 - Automation Enthusiast

In my base, I have a column called Authors. I would like to make a formula so if the Authors field has “Hoch” in it, it will say Author, and if it doesn’t, it will say Not Author.
How do I do this?

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

Here you go:

IF(
FIND("Hoch",{Authors Field}),"Author",
"Not Author"
)

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

Here you go:

IF(
FIND("Hoch",{Authors Field}),"Author",
"Not Author"
)

@ScottWorld
Thank you so much!