Using the "Like" operator in Custom Formula

Using the "Like" operator in Custom Formula

HI there,

Can someone please explain the way to use the "LIKE" operator in an IF statement to compare strings? I have tried the following but am not getting the results I'm after.

if( "CurrentStatus" like 'Rejected*','Unsuccessful','Pipeline')

Thanks

Matt


      • Sticky Posts

      • What’s New in Zoho Analytics – September 2025

        Hello Users!! In this month’s update, we’re raising the bar across multiple touchpoints, from how you bring in data, plan and track projects to how you design and brand your dashboards. We’ve added the all-new Gantt chart for project visualization, expanded

      • Announcing Agentic AI - Ask Zia!

        We are delighted to roll out the new agentic AI capabilities in Ask Zia, where every stage of the BI workflow is assisted by AI. With a human-in-the-loop approach, Ask Zia ensures that you’re in command of the decision, while AI handles the complexity.

      • Invitation-Based User Access in Zoho Analytics

        Hello everyone, We’re rolling out an important update on how users are added to your Zoho Analytics Organization and Workspaces. Previously, when admins added users, they were automatically added to the organization. Moving forward, to improve security

      • Zoholics Europe 2025: Your Ultimate Data Analysis (Zoho Analytics) Workshop Experience

        Why should you attend? This year, Zoholics Europe 2025 is putting data analysis centre stage. With a dedicated workshop designed to answer all your data-related questions, you’ll gain practical skills, real-time solutions, and expert insights that you

      • [Webinar] Evolving BI & Analytics in the Age of AI

        Artificial intelligence is redefining how data is collected, analyzed, and leveraged across industries. As businesses strive to become more agile and insight-driven, traditional BI and analytics must transform to meet new demands. AI-first organizations

        • Recent Topics

        • Zoho Books | Product Updates | April 2025

          Hello partners, We’ve rolled out new features and enhancements to elevate your accounting experience. From FEC report to BillPay Add-on, these updates are designed to help you stay on top of your finances with ease. Export Transactions in Factur-X Format

        • Please cancel my trial / subscription

          I’m doing a free trial of the Enterprise version. I’m trying to cancel it and make sure I won’t be charged a subscription. I can’t follow your help pages for this because I don’t get a sidebar with the details. I’ve wasted a lot of time trying to do this.

        • 日付別メール送信リストの作成

          日々顧客に個別にメールを送信しています 日付別に送信先リストを作成することは可能でしょうか？

        • 【Zoho CRM】キオスク機能のアップデート

          ユーザーの皆さま、こんにちは。コミュニティチームの中野です。 今回は「Zoho CRM アップデート情報」の中から、キオスク機能のアップデートについて、 一部を抜粋してご紹介します。 キオスク機能とは？ 特定の処理を行うための専用画面（キオスク）をノーコードで作成できる機能です。 自社の業務プロセスにあわせた画面の表示、タブをまたいだ処理などが可能です。 本アップデートにより、キオスクの柔軟性と操作性が大きく向上しました。 詳細について以下より確認しましょう。 ＜目次＞ データ取得機能：「データ選択不要」のデータ表示

        • Zoho CRM IP Addresses to Whitelist

          We were told to whitelist IP addresses from Zoho CRM.  (CRM, not Zoho Mail.) What is the current list of IP Addresses to whitelist for outbound mail? Is there a website where these IP addresses are published and updated?  Everything I could find is over

        • Ability to Add Custom Favicon to Zoho Desk Survey Window

          Dear Zoho Desk Team, Greetings! We would like to request the addition of a feature that allows users to add a favicon displayed in the Zoho Desk Survey window. Currently, there is no option to set a favicon. Customizing the favicon would allow businesses

        • Campaigns Place-holder $ tags

          Hi there I’ve just started using Campaigns and I’ve been making use of the placeholder inserts available when constructing the email. However, in my contacts in CRM rather than have a first name and last name field I put their full name into the last

        • Setting Up Automated Lead Nurturing Campaign in Zoho CRM

          I want to create an automated lead nurturing campaign within Zoho CRM and Zoho Campaigns with the following requirements: Leads should receive a sequence of 5 emails, spaced 3 days apart. If a lead clicks a link in any email: A notification should be

        • Books Not Matching Transactions from Feed - "The total amount does not match with that of the transaction"

          Recently, transactions that are transfers from a foreign currency (FCY) account to a base currency (BCY) account are not allowing for matches with transactions from the bank feed. Please see the screenshots below: As one can see, the amount is in the

        • Inline and background image with from scratch contract type

          When using the "Create From Scratch" option to build a new contract type is it possible to add inline images as well as a background image? We want our company logo on the cover page as well as each page header and also have a background image that we

        • Is it possible to display a graph of data within a contact record

          I’ve had someone create deluge code to import data from another SaaS platform into Zoho CRM for my swimming pool company. This data is stored within each customer’s contact record under a custom module called "Chemicals" and is updated weekly with new

        • Adding the date of an expense to an invoice

          Hi there, I have uploaded a whole load of expenses. I have prepared an invoice, and want to add the expenses. However I need to show the date which the expenses were incurred - how can I do this in the template? Thanks Michael

        • How to Link WooCommerce Orders to Contacts in Zoho CRM for Better Customer Segmentation?

          I’m running a fashion e-commerce website using WordPress. My sales staff usually rely on customers’ past orders to segment and re-approach them for sales. However, I’m not sure how to apply Zoho CRM for this purpose, since I can’t link the orders from

        • [WEBINAR] - Importing PDF bank statements into Zoho Books [ Indian and GCC editions ]

          Hey everyone! Manually entering the bank statements into your accounting software for reconciliation purpose is a tedious and error-prone task that can compromise the accuracy of your accounts. The banking module in Zoho Books helps you solve this problem

        • Download a file from within a zoho creator widget

          I have a widget running in Zoho Creator , it displays uploaded documents in a table file, and I have added a download link in the view. ( The widget is created with html, css and javascript). I do not succeed in getting the download working. Do I have

        • Let’s Talk: What’s a Good Engagement Rate in 2025?

          What engagement rates are you seeing as healthy for Instagram, Facebook, & LinkedIn (higher education focused?) My top posts on the university alumni pages I manage typically see a 4-9 % engagement rate. What is industry average? Is this measured by the

        • Mandatory DEFAULT for Billable and markup percentage

          Hello. So we have been using books and process bills from vendors that are to be invoiced to customers. When we convert from a PO to a bill we can enter the customer name on the line items and that is great. However, we would like to know if the default

        • why is zoho assist server so slow

          Hello why is zoho assist server so slow, i use it every and and have fast speed at either end of the connection but zoho assist take upto 10 seconds per click, I connect on the chat they we will have a look and come back saying they have done a reset

        • Can no longer upload my own Notebook cover

          I've had Notebook for over a year and have been able to create my own notebook covers, but when I tried to upload my own cover for a new notebook today, the upload feature has suddenly been starred, requiring me to upgrade my account. When did this

        • Nested notebooks

          Dear Sir/Madam, I would like to know if it is possible to nest notebooks. It would be very helpful when there are too many, as it would improve organization. Thank you for your response. Best regards.

        • Third Insight - The Importance of Data Segregation

          The Wheels of Ticketing - Desk Stories The Importance of Data Segregation Data segregation In ticketing systems, data segregation organises data into logical groups or categories to reduce ticket backlogs and resolution time and improve the overall customer

        • Inquiry Regarding Adding labels to Quick View Cards in Report

          Dear Zoho Support Team, I have created a report and designed it's Quick View and formatted the records as cards. However, I would like to include the field labels alongside the values for better clarity, as users may find it challenging to interpret the

        • Facing Issues? No typing—just record and share

          We get it—reporting a technical issue isn’t always easy. Explaining what went wrong over text can be time-consuming, and screenshots often miss the full context. That’s exactly why we want to spotlight a tool that’s been quietly waiting in your Zoho Recruit

        • Creation of Path and subpath

          In order to improve the structure of the website for better organization, I would like to consider that when publishing a page, it can be within a section and sub-section. For example, if I have an events option in the menu, I can put past events and

        • onDuty Request approval from API

          use case We have custom CRM modules and meeting devices where a user can add meeting details We are pushing these details to People using onDuty Request API Now what we want is If the onDuty request is pushed using API, it should be auto approved i-e

        • Move a mail to another inbox without being parto of it.

          I would like to move an email from my inbox to another team's inbox in, without being a member of that other team. The goal is to assign the customer's request to the colleagues who manage that inbox, so they can take over and handle it.

        • Zoho CRM CPQ NOT in criteria patern

          Hi, It would be great to have the logic-block of "NOT" in the criteria patern. Currently, only "AND" and "OR" are valid criteria when using the product configurator. Often, a "NOT" logic-block would greatly increase the usability of the CPQ. Example:

        • Filter by Portal User Reports no longer work

          I've had multiple reports that filter the data that shows based on the portal user - thisapp.portal.loginUserName(). They have worked fine for years but a few months ago they stopped working. Currently, no records appear in the report. Also, this is the

        • Quickly migrate attachments to Zoho CRM without having to restart the process multiple times

          Hello everyone, Customers often want to transfer all their data and attachments to Zoho CRM when they're switching CRMs (or moving from one Zoho CRM org to another). Admins use the built-in import tool to perform these migrations. There's a common source

        • Numeric Field Issue

          Hi We are trying to import deals but hitting a roadblock every time. If I create a single line field, the data imports fine for this field (it's a currency field in csv). I have found I can't sum this field though when trying to do a revenue report. When

        • Transfering Creator data to Books

          Hello, I am working on a new app that will have suppliers, products, customers, order, etc. When I will be finished, I will want the end result (an order of goods) to be transfered to Books for invoicing and accounting. I will also use the supplier order

        • Your Incoming has been blocked and the emails will not be fetched in your Zoho account and POP Accounts

          Can some on help me regarding our account . thank you so much

        • Custom code ass to header and footer code doesn't appear

          I am trying to insert custom code into both the header and footer of my Zoho site. I edit the site "general settings" as demonstrated in the various articles, click save, but the code does not appear on my site. Is there something special I need to do

        • Geo-Powered Retail Intelligence with Zoho Analytics

          In today’s highly competitive retail landscape, data-driven decisions are no longer optional — they’re essential. While businesses collect vast volumes of data across regions, stores, and customer segments, the real value lies in how effectively this

        • In the Pivot table in the value section i want to the actual value instead of sum or count

          I am creating Early/late Check and check out in pivot report based on Zoho analytics I need the data to include: Employee Name Late Entry, Early Entry, Early Exit, Late Exit, First In, Last Out, and Total Hours.

        • Outgoing blocked again.

          Hi Dear, My outgoing mails are blocked again. I am just using it as normal business emails going in and out. Could you please help fix the problem? I am happy to support where I can do to make it work properly. Thank you very much. Aurora

        • Tip of the Week #54 – Automatically assign emails to your team members.

          Managing incoming emails can feel exhausting at times. But what if you could ensure that every email reaches the right team member — without lifting a finger? That’s where automatic email assignment comes in! With Zoho TeamInbox, you can easily set up

        • Keep your forms spam-free with CAPTCHA

          Is your online form getting loads of unwanted responses? Tired of spam ruining your valuable form data? CAPTCHA is the solution you are looking for. CAPTCHA (Completely Automated Public Turing test to tell Computers and Humans Apart) is a simple yet effective

        • how to get the first word in string using deluge?

          let say I have string "David Beckham". how to get just "David" using deluge? I need to get the first word in string using deluge?

        • Access a field from incoming webhook Zoho Flow

          I would like to further process an incoming webhook in zoho flow. How can I access a field in the script / custom function. I tried this in many variations but not working: exfield=${webhookTrigger.payload.AnalyseErgebnis}; I would be very grateful if

        • Next Page