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.
My challenge is to do a search that looks for records where my input is part of the company name. So essentially I am looking for a "contains" function.Example searches:1.Input: "sephora"Target: "company" field in record: "SEPHORA Inc."2.Input: "GoSp...
Hey guys,I spent the day trying to get my head around a moving average function. In my case I want to calculate the 7 day average of my Google Ads CPL (cost per lead) metric. I have daily data from Google Ads in my base along with all important metri...
Ok, that is very interesting!I just tried your function and it resulted in an error again. Then I changed the {Field Name} from {Unternehmen} to {Name} and suddenly it worked for my input. Maybe it has something to do with the field type of {Unterneh...
I tried to add the formula field but it returns "0" for all records if I enter "Strabag".When I enter the complete name (in this case "STRABAG BMTI GmbH & Co. KG") I get a "1".This is the formula:FIND("NAME OF COMPANY GOES HERE", {Unternehmen})
Hi @ScottWorld !Thank you for helping out.I tried using this formula:FIND("{{lower(1.Company)}}", {{lower("{Unternehmen}")}})It outputs the company but only if it matches exactly my input. So if I put "SEPHORA Inc." just like in the record, it finds ...