Function Used to Find Specific Strings

ztrean · September 17, 2020, 8:48pm

I’m looking for a function that would return a specified value if the characters “ACT” are found in another cell. Which function would work best for that capability?

Ryan · September 17, 2020, 8:48pm

Hey Zachary!

You can use a contains function for this!
Contains([Column], “ACT”)

system · October 17, 2020, 12:31am

system · October 31, 2020, 1:54pm

system · November 20, 2020, 3:20am

system · December 9, 2020, 10:50am

system · December 28, 2020, 10:28pm

system · January 18, 2021, 2:47am

system · February 7, 2021, 11:26am

system · February 28, 2021, 8:50pm

system · March 22, 2021, 6:53am

system · April 12, 2021, 8:37pm

system · May 4, 2021, 3:53pm

system · May 26, 2021, 11:47am

system · June 18, 2021, 3:46am

system · July 10, 2021, 11:59pm

system · August 2, 2021, 12:11pm

system · August 25, 2021, 1:20pm

system · September 18, 2021, 1:11am

system · October 11, 2021, 4:40pm