How can I stop a NOW() from update every time I open the sheet?

How can I stop a NOW() from update every time I open the sheet?

Hello,

I'm trying to use the current function =IF(B1<>"", NOW()). Is it possible to update the NOW() function only when the B1 cell is modified and not when the sheet is opened?

Best regards


      • Sticky Posts

      • Feature enhancement: Highlight rows based on a cell value

        Hello Sheet users, We're excited to announce a new feature enhacement, shaped directly by your valuable feedback! As you might know, conditional formatting is a great tool for anyone dealing with large data sets. Previously, if you’ve ever wanted to draw

      • Create and save user-specific filter views with Zoho Sheet

        The filters in Zoho Sheet have become even more collaboration-friendly. Previously, whenever you filtered any data, the filtered view will be updated for all the spreadsheet collaborators. This disturbed the data for others working on the same file. With this new update, you can apply data filters without altering the view for other collaborators in the file.   Collaborate with user specific filters   Let us say you are working on a sales report spreadsheet in real time with two remote colleagues. If

      • Revamped Print in Zoho Sheet—customized for paper

        The latest enhancements to Zoho Sheet's Print settings allows you to print a worksheet or a selected range, with customizations that make the data comprehensible, even on paper.   Customize header and footer Make your spreadsheets meaningful with a relevant header and footer. You can now choose to display the file name, sheet name, current page number, total pages, date, and time as the header and footer in your print view. Besides the predefined elements, you can also give a custom text for header/footer.

      • Slicers are now available in Zoho Sheet—filter your data interactively

        At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add,

      • Check out the new Checkbox in Zoho Sheet

        Checkbox, the simple GUI widget that lets you choose between two mutually exclusive options i.e Yes or No, is now in Zoho Sheet. Having made it across the web, Checkbox is familiar but is still elusive to most spreadsheet software. Special developer ribbons, macros and all other complexities to add a checkbox to a spreadsheet? Not in Zoho Sheet. How to add Checkbox to Zoho Sheet? Adding a Checkbox in Zoho Sheet is simple. Select a cell/range and choose "Checkbox" in "Input Controls" under the Format

        • Recent Topics

        • How to Export Filtered List of Contacts?

          This seems like it should be simple, but I'm stymied. I'm trying to export a filtered list of my Contacts for analysis in a spreadsheet. The use case is that I'm an ecom business based in the US. The bulk of our customers are individuals stored as Contacts.

        • Feature request - pin or flag note

          Hi, It would be great if you could either pin or flag one or more notes so that they remain visible when there are a bunch of notes and some get hidden in the list. Sometimes you are looking for a particular name that gets lost in a bunch of less important

        • Merge Join PDFs Zoho Creator

          Hi all, I have a field where users upload PDF, is it possible to join those pdfs into one with a function or something? Regards.

        • ERROR CODE :554 (certain recipients are bouncing my emails)

          I had set up my SPF, DKIM, and DMARC properly as far as I know, and they look proper according to mxtools and some other online checking tools. My mail does go through to gmails (although still was in spam at first), but certain domains bounced me. I'd

        • Adding bills from docs *** Internal Error ***

          Same internal errors in Chrome & Edge !

        • Printing Mailing labels

          Is there any way to adjust the size of the printing labels? or product would I use to print labels from Zoho? Thanks, Josef Krieger

        • Formatting Mailing Labels

          I want to use the "Print Mailing Labels" function on the drop down list, but I am not seeing a way to change the formatting on the mailing labels. At the moment, the information that appears on the mailing labels ARE NOT mailing addresses, but random information.  I would also like to change be able to change the size of the labels.  At the very least I would like to know what type of labels I can get that would be the correct size.  

        • Zoho Creator delete validation seems like does not support <br> html code

          Validation Workflow in Create or Edit, We can use this styling code eg: <br>, <b>, <u> Those very simple code in those validation (in Create or Edit) But, for Validation (In Delete) Zoho Creator seems like does not support it. The alert task just shown

        • Can't create Workflow for Module 'Service Appointments'

          Hey everyone. I am trying to create a workflow from FSM to Desk. When I start the creation process I select the Module (Service Appointments) and then title it and hit next and it just sits there. Now If I select a different module it works fine. Have

        • CRM x WorkDrive: File storage for new CRM signups is now powered by WorkDrive

          Availability Editions: All DCs: All Release plan: Released for new signups in all DCs. It will be enabled for existing users in a phased manner in the upcoming months. Help documentation: Documents in Zoho CRM Manage folders in Documents tab Manage files

        • Tags with Zapier

          Maybe I'm missing something....I hope so... Using tags for triggers is a key need.  This prevents us from having a ton of different lists. I am trying to find out how to add a tag using zapier when someone makes a purchase....but it doesn't seem to be

        • Zoho Sheets working offline

          Hi, I am looking for the ability to work offline in Zoho Sheets, but currently I cannot find the process to complete this. Does someone have any ideas or steps I might have missed? Also does Zoho Sheets have the "Format as Tables" function as is currently

        • Free Webinar Alert! Building Your Brand: Solopreneur Tips to Use Zoho Mail

          Hello Zoho Mail Community! We’re excited to invite you to an exclusive session: "Building Your Brand: Solopreneur Tips to Use Zoho Mail." In this webinar, we’ll explore how Zoho Mail helps solopreneurs create a professional brand with custom email domains,

        • ZOHO Mail required to use CRM Mail Merge?

          Is ZOHO Mail required to use CRM Mail Merge?

        • How can I create a deal with multiple payment milestones in Zoho CRM?

          Hi. We are a services based company and most of our deals involve monthly invoicing for T&M work or payment milestones for fixed price projects. How can I create a Deal in CRM that shows monthly (or multiple) payment milestones, rather than just the total

        • Client scripts for Zoho Books ?

          Good day everyone, I am looking for a way to be able to interact with the Quotes and Invoices as they are being created. Think of it like Zoho client script in Zoho CRM. But for the life of me I dont see a way to do this. The issue with having function

        • View and manage your records in Calls, Events, Tasks, Contacts, and Accounts with Table View

          Hello everyone, So far, Table View was available for the Tickets module; now, we have included it for the following modules as well: Calls Events Tasks Contacts Accounts Managing customer interactions and activities often requires navigating through multiple

        • Contacts are imported successfully but ignored when I send a campaign (due to non-marketing type)

          Can someone please help, When we sent a campaign yesterday, we received the following message: "The number of contacts from the selected mailing lists are 161. We have ignored 11 contacts due to its non-marketing type." So only 150 people got the message.

        • Zoho Books | Product updates | March 2025

          Hello users, We have rolled out new updates in Zoho Books to enhance your accounting experience. These include the ability to create workflow rules for manual journals and Multi-Factor Authentication (MFA) for customer and vendor portals. Explore these

        • Spell Checker in Zoho desk

          Is there a way to set always check spelling before sending? Outlook does this and it is a handy tool to avoid typos

        • Zoho Creator not accounting for time change

          I have the timezone to my Creator application set to Eastern Standard Time(SystemV/EST5EDT). This is under the GMT -5:00 category. I was under the assumption that since EDT was present in the time setting that my application would switch automatically

        • How to add Line Breaks for Task Description with API v3

          How do we add line breaks to the Description field of a Task using API v3? https://projects.zoho.com/api-docs#tasks#create-a-task Previously I was using "<br>" with the old API. When I use that with v3, it just prints "<br>" as text instead of adding

        • It would be very helpful to be able to use variables in the formula columns

          Currently, variables can be used only in aggregated formulas. It would be great to be able to use them in regular formulas as well

        • Display name in Zoho Desk Ticketing system

          We are in the trial phase to implement a Ticketing system. As our company uses several generic emails, such as service@abc.com and service@xyz.com across different branches, the uniqueness of usernames (full names) becomes crucial for our business. Without

        • Create a new module with first name & last name, and join the two when viewing records

          I've created a new module, and I have first name / last name fields (I've renamed the record name field as last name). When I'm viewing a record, I'd like to see "Bob Smith" at the top of the page and in lists, not just "Smith" as I have today - basically the same experience you get when editing / viewing leads in the leads module.

        • Announcing the all-new Offers Module and Offer Approvals in Zoho Recruit

          We're happy to introduce - Offers as a module. As we all know, Zoho Recruit is a powerful Applicant Tracking System that can help us. One of its key features is the ability to generate and approve offer letters. When a candidate is the right fit for a

        • Extract first and last name

          I am trying to build a custom function in Flow, when a new Zoho Booking is added I want to split the Name field into first last name. I understand the function needs to be a string and this works but I am unsure how to write this in the flow script. result

        • Desk Contact Name > split to First and Last name

          I am new to Zoho and while setting up the Desk and Help Center, I saw that new tickets created or submitted from the Help Center used the Contact Name field. This would create a new Contact but put the person's name in the Last Name field only. The First

        • I have a problem which is that the posts are not published

          I have a problem, which is that posts are not published. Since yesterday, I have tried more than 50 separate posts without any new information.

        • Uploads in creator app

          So I have a file upload in the app, I can upload the file to it easily, but can't then download that file, there appears to be no option to?

        • NOW Zoho Creator still cannot bulk download Image or File Upload Field

          The filedownloader has been deprecated for 5 years. Until now, we still cannot have a replacement tool. How can we bulk download the file that we uploaded to Zoho Creator. Previously, it was so simple to bulk download all those files. But now failed to

        • Introducing Linkthread by Zoho Social — our new link in bio tool

          Hey everyone, We hope you're all doing amazing. We always love bringing features and tools to make your social media marketing journey easier, and today, we've got a brand new tool that we'd like to introduce to you. We know how important it is to make

        • Client Script | Update - Introducing Subform Events and Actions

          Are you making the most of your subforms in Zoho CRM? Do you wish you could automate subform interactions and enhance user experience effortlessly? What if you had Client APIs and events specifically designed for subforms? We are thrilled to introduce

        • Ayuda: Cómo Integrar / configurar el Facebook API de conversiones con Zoho Sites

          Buenas tardes foro, no sé si ya se ha respondido esta solicitud, soy un usuario de zoho con nulo conocimiento en códigos, programación y queria saber si existe un tutorial o un paso a paso de cómo Integrar / configurar el Facebook API de conversiones

        • Add Mileage Tab on Expenses

          Hello, the 'Add Mileage' tab is not visible. How can I enable it? I checked the settings, and my user has admin privileges. I also enabled mileage in the policy, but the 'Add Mileage' tab is still not visible. What could be the issue?

        • Understanding "Deposit from Other Accounts" vs. "Sales Without Invoices"

          Hello, Zoho team! I am a new Zoho Books user trying to correctly input some historical financial data. I'm hoping you can help me understand best practices for when to use "Deposit from Other Accounts" vs. "Sales Without Invoices." I'm an author who receives

        • Update Client Record based on creation of custom module record

          Hi! Hoping for someone's help with this one. I have a custom module called 'Agreement History. Whenever a deal is won, it creates a new record in this module with associated 'Products' and 'Clients' to track rental history and contracts. What I'm trying

        • I can't auto-scheduling calls down - the code does not change anything

          Hi, I was trying to set a function that auto-schedules calls based on their call result; i.e "Requested more info". I had also included a reminder to send an email in the code. I logged a test call and nothing changed. Is there anything wrong with the

        • setting owner of note when adding via deluge

          My organization has requested the ability to mass update the notes related list in the deals module. Since this can't be done with the mass update feature, I created an update "notes single" line field and created a workflow rule that triggers a function

        • Enable History Tracking for Picklist Values Not Available

          When I create a custom picklist field in Deals, the "Enable History Tracking for Picklist Values" option is not available in the Edit Properties area of the picklist. When I create a picklist in any other Module, that option is available. Is there a specific reason why this isn't available for fields in the Deals Module?

        • Next Page