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

        • RouteIQ for Zoho FSM

          Beste, Zou wel top zijn dat we een RouteIQ hebben voor FSM aangezien we constant moeten zien wat de beste route is voor onze monteurs. Nu moeten we een speciale aparte programma hebben om de beste route te berrekenen voor onze monteurs aangezien de planning

        • Let's Talk Recruit: An approval process with zero follow-ups

          Welcome back to our Let's Talk Recruit series! Today, the topic of discussion is the Approval process. We’ll discuss how approval workflows function in recruitment, explore real-world use cases, and show how automation in Zoho Recruit can streamline approvals

        • Block certain emails from creating tickets

          Hi there! We get a lot of tickets into Zoho desk from people emailing our support email that feeds into Zoho. We have created some 3rd party accounts using our support email and we get notification emails from these accounts. These emails create tickets.

        • Customer Statement Templates

          Hi  In know that Credit Note Templates have already been proposed but I would also like to see Customer Statement templates as well please. Thanks Gene

        • Where to find org ID and department ID?

          Hi there All the existing info on this seems to be incorrect or out of date. It's not in my URL, it's not in the developer space > APIs anymore like was suggested in some other forum posts. How do I find it?

        • Turn off Knowlege Base Follow options and Follower lists

          Is there a way to hide or turn off the option in the Knowledge Base for users to follow specific departments/categories/sections/articles? If not, is there a way to turn off the public list of followers for each of those things? Otherwise, customer names

        • Zoho desk not sending call reference to user

          Hi, I am using zohone desk and have setup the call logging email address but sadly users are not getting a call reference notifying them that the call has been logged also can't see the updated call when it is going through faces. My question is, is there

        • Display CRM account field on Zoho Desk Ticket

          I have linked a custom CRM Account field for "Customer Care Lead Advisor" with Zoho Desk Accounts. I know the data has synced correctly as I am using this field for some automations based on this lead advisor field. When viewing a ticket that is linked

        • What is the difference between a template and a snippiet

          Hi there, I am currently working on optimising our service desk and improving the consistency of our responses. I have come across two tools that appear to help do this, templates and snippets. I was wondering what the similarities and differences are

        • Is there a way to set up templates for commonly occurring issues on Zoho Desk

          Hi there, We have recently migrated our service desk over to Zoho. I was wondering if there is a way we can set up custom templates for specific requests that we commonly get from our customers. Example: Customer often requests a password reset. There

        • Missing "Created_Time" Field in Zoho CRM API Search Results

          Hello, I've noticed that the "Created Time" field is visible in the Zoho Canvas view for my Accounts Module. However, I'm unable to retrieve this field's value via the Zoho CRM API. Specifically, when using the /search endpoint for the Accounts module,

        • Problem connecting social accounts and file upload

          I have two brands that I manage in Zoho, each with their own social profiles. I didn't have any issues for the first few months, but recently the Instagram for one got disconnected and no matter what I've tried, it won't reconnect. If I go into the settings

        • Marketing Automation Emails Going to Spam

          Google is trapping all the marketing automation emails in spam. My domain has a perfect reputation and it looks like Zoho has a low reputation which is sending it to spam. When I pull the email out of spam and click on a link in the email, I get this

        • Invalid OAuth Token When Using Zoho CRM API with Postman

          We're in the process of integrating Zoho CRM with our Django backend and currently testing the API endpoints via Postman. I've forked Zoho's official CRM REST API collection in Postman for this. Steps Taken: Created a Self Client via Zoho API Console:

        • Device Credentials

          Connection Credentials for my device. Where is this displayed in the application.

        • is there a better way to routinely export my project timesheets?

          Hi there, I am somewhat happy with how Zoho books handles time.  One thing that is missing is more user driven control over my data.  I have a workflow where I constantly need to give customers feeds of work done.  So I pick a project, and would ideally

        • Zoho Flow - Create CRM Meeting - Expected input type is jsonobject

          I'm trying to use the Create Module Entry action in Zoho Flow to create a meeting in Zoho CRM. The participant field is throwing an error during debugging: "Zoho CRM says "Invalid input for invalid data. The expected input type is jsonobject." I've tried

        • Assistance Required for Fetching Custom Subform Data in Zoho CRM Widget

          Hi Team, I am facing an issue with my Zoho CRM Widget. In the Quotes module, there are two Subforms — one is a predefined Subform, and the other is a custom Subform that we have created. In the Inspect console of my widget, I am only able to see the predefined

        • Introducing Zoho Projects Plus!

          Just as each project you execute is unique, so is the project management requirement. Following a one-size-fits-all approach to managing your projects might limit the possibilities of exploration and advancement for your teams. Acknowledging this, project

        • Zoho Mail Shared Mailbox migration

          Hello! I am in the process of migrating our whole email infrastructure to Zoho Mail. We currently use cPanel for our email accounts and we want to migrate them to Zoho Mail using the migration tool. The problem is that we use an email for our sales department

        • Have an input card for zobot that could collect Name, Email, and Phone or a message all at once

          It would be great to have an input card for the codeless bot in a form style that allows it to ask all relevant questions at once. at any point in the chat flow or conversation, This approach would simplify the interaction, making it easier and more straightforward

        • Change DKIM From 20248 Bit Key to 1024 Bit Key

          I am having issues trying to change the Bit Key in DKIM from 2048 to 1024 so that it works with my Shopify Account. I can only find information on how to configure this when the Domain Key is added, but I couldn't find any details on how to change it

        • Update Date field using a custom function

          Hello, In Zoho FSM, Equipments module, I created the following custome fields for tracking the calibration of the eqipments: "Calibration Required"; type: Checkbox; API Name: "Calibration_Required__C" "Calibration Interval (Days)"; type: Number; API Name:

        • Zoho CRM API, Python SDK v7 Quoted_Items

          Hello. How do I use this SDK to retrieve the Quoted_Items from a Quote and downstream the items in a Sales Order I can see references to a constant INVENTORY_MODULES_ITEMS = ["invoiced_items", "quoted_items", "purchase_items", "ordered_items"] But I cannot

        • Zohoのシステムについて

          ここで提供しているofficeソフトが使いたくて質問するためにユーザー登録をしました。企業を対象として事業展開されているようですがzohoのシステムがよくわかりません。writerやsheetなどのソフトを利用してもかまいませんか？また利用するときの費用はどうなっているのかとか組み込まれているbasicについての資料とか、要望事項を記してくださいと書かれてあったりとか質問したいことがたくさんありますがこうした質問が許されているのかもわかりません」 ここの書き方もよくわかりません

        • Email de outra pessoa ja associada ao meu dominio

          Tenho um dominio e está falando que o email da pessoa ja está associada ao meu dominio

        • Pin multiple columns and adjust column widths in CRM subforms

          Hello all, Subforms act as secondary forms or tables in which you can associate multiple line items to a primary record and thereby ensure more structured and comprehensive data organization. We've made some recent enhancements to subforms. Here's what's

        • On create of Amc module get sub form data of last row and update in Schedule Vist End Date field in zoho crm

          @Iswarya B G @Bhoomi Joshi @Abinaya Praveen @Ishwarya SG @Haiku Technical Support On create of Amc module get sub form data of last row and update in normal module field Schedule Vist End Date field in zoho crm

        • Magento 2 as data source for Analytics

          I see that Shopify is in Beta as a data source, any change that Magento 2 is in the works? We currently use Metrilo to parse our eCommerce data for marketing and would love to keep that inside our Zoho ecosystem. Thank you!

        • Zoho Finance Issue in Deals (ZOHO CRM)

          I create almost all estimates/Invoi in Zoho Finance when I convert a lead into a deal or a contact into a deal. But in the Deals section, when I click on any person’s deal, I don’t see the estimations or invoicing from Zoho Finance at the end. May I know

        • Restrict card movement in Kanban View

          Hello everyone, I’m wondering if there’s a way to prevent users from moving Deal cards in the Kanban view when grouped by Stage. On the Deal details page, I’ve implemented several validations to ensure users cannot change stages until all conditions,

        • Everything you want to share — in ONE link

          Hey everyone, Say hello to our very own link in bio tool – Linkthread is designed to create a single customizable link that contains everything you want to share with your audience on social media. Welcome to the Linkthread Community! What's Linkthread?

        • Automate Zoho Meeting Creation via Blueprint (Leads & Accounts)

          I need help automating Zoho Meeting creation during a blueprint transition in both the Leads and Accounts modules. Requirements: Triggered via blueprint Read meeting start time (DateTime field) and internal participants from CRM Create Zoho Meeting via

        • Cómo guardar datos de subformularios en filas individuales en Zoho Sheet o Google Sheets

          Hola comunidad, Estoy trabajando con un formulario principal en Zoho CRM llamado Clientes, el cual incluye un subformulario llamado Productos (máximo 3 productos por cliente). En el formulario principal tengo los siguientes campos: Cliente Teléfono Correo

        • ZOHO BOOKS EXPERT

          We are planning to migrate from Quick Books to Zoho Books, and are looking for a professional with experience in migration to Zoho Books and the setup of Zoho Books. Currently, we have two companies and two Quick Books accounts, and we want to integrate

        • Estimating Project Costs in Zoho Projects – Based on Hours and External Costs

          Hi everyone, I'm currently setting up a project in Zoho Projects and working on implementing a budgeting structure. I’ve already enabled cost tracking based on hours logged to tasks, but I’m looking to expand this to estimate total actual costs, based

        • Assistance Required for Zoho Bulk Import Error

          Hi, I am currently attempting a bulk import in Zoho with a small batch of records to test if the import will be successful. However, despite matching all fields correctly, I continue to encounter the following error: "Not a standard user: Prospect Owner."

        • Page Break

          Is there a way to set page breaks in Zoho Sheet. I couldn't find anything about it on the board.

        • Zoho Projects API - Searching Projects by Custom Field

          Hi How can I search all projects by a custom field? I can confirm that using the search_term parameter as documented here does not work for me: https://www.zoho.com/projects/help/rest-api/search-api.html#alink3 My search term is "22424", which corresponds

        • A few Issues when using "Pay Bill via Check"

          We have quite a bit of issues with how paying for Bills via Check works. Would love some feedback from the Zoho team in case we are doing something incorrectly. 1. When we go from a vendor and select "Pay Bill via Check" option, we see ALL the outstanding

        • Next Page