Zoho Sheet : la toute nouvelle feuille de calcul

Zoho Sheet : la toute nouvelle feuille de calcul



Zoho Sheet est passé  d'un simple tableur  pour la collecte de données et les calculs à une puissante application dotée d'une  intelligence artificielle pour une analyse transparente. Grâce à ses dernières mises à jour, Zoho Sheet permet aux utilisateurs de travailler plus facilement avec des données dynamiques tirées de sources externes intégrées à leurs feuilles de calcul.

Synchroniser des données contextuelles d'autres services

La fonctionnalité "Link External Data" de Zoho Sheet a été transformée en data connection. Grâce à elle, vous pouvez intégrer et synchroniser des données contextuelles tirées de sites web externes, ainsi que d'autres services Zoho, comme Zoho CRM, Books, Projects, et bien d'autres !


Champs de feuille de calcul dynamiques

Le modèle de fusion est maintenant disponible dans Zoho Sheet ! Associez des fichiers sources à partir de votre appareil, de votre compte Zoho Sheet ou d'autres applications Zoho, comme Forms, Creator et CRM. Il est possible de sauvegarder ou de partager les enregistrements de données contextuelles générés grâce à des options de personnalisation.


Tableaux prédéfinis

Nous avons lancé l'une des fonctionnalités les plus demandées par les utilisateurs cette année : les tableaux ! Vous pourrez formater vos données sous forme de tableaux, les personnaliser et les utiliser dans des formules de façon transparente !


Enregistrements de collaboration complets

Historique des changements fournit les détails des modifications apportées à vos feuilles de calcul. Il permet désormais de conserver et d'accéder à un enregistrement contextuel de toutes les valeurs saisies, modifiées ou supprimées dans chaque cellule grâce à l'historique des modifications !



Nouvelles façons de formater vos feuilles de calcul

Nous avons renouvelé l'ensemble de la bibliothèque de polices avec de nouvelles polices qui vous aideront à mieux représenter vos données. Il existe plus de 500 polices dans la bibliothèque à disposition !


Vous pouvez définir des thèmes pour vos feuilles de calcul et gagner du temps en modifiant et en formatant manuellement le texte, les graphiques et les couleurs. Il est également possible de personnaliser les thèmes en fonction de votre marque ou du style de vos feuilles de calcul, ce qui facilite la cohérence du contenu pour les collaborateurs.


 
De plus, il est possible de visualiser et de comparer les données de vos feuilles de calcul à l'aide des barres de données, un nouvel ajout à la série des mises en forme conditionnelles !


Améliorations utiles pour vos appareils portables

Profitez maintenant du même confort de travail sur votre MacBook tout en utilisant Zoho Sheet sur votre iPad ! Grâce à la compatibilité avec les claviers externes et aux gestes intuitifs, il est facile de travailler sur vos feuilles de calcul à partir de n'importe quel endroit.


 
Utilisateur d'Android ? Il y a également quelque chose pour vous ! Avec cette mise à jour, nous avons entièrement modifié l'interface de l'application pour faciliter la navigation et l'utilisation. Nous avons également ajouté un grand nombre de nouvelles fonctionnalités à l'application. Découvrez-les !
 
L'équipe Zoho France

    • Sticky Posts

    • Les Zoholics sont de retour !

      Bonjour à tous,  Nous avons (encore une fois) une bonne nouvelle à vous partager : nous allons enfin pouvoir nous rencontrer ! Et pas dans n'importe quel contexte, mais lors de notre conférence annuelle : les Zoholics ! Mais que sont les Zoholics me direz-vous

    • Novembre : un résumé de ce qui s'est passé le mois dernier sur Community

      Bonjour à tous,  L'année 2021 arrive presque à sa fin, mais nous continuons à avoir de nombreuses actualités à vous partager. En voici un résumé ! Nous avons eu notre première session "Ask The Experts" sur notre nouvelle version Zoho One 2021 et vous

    • Août : Un résumé de ce qui s'est passé le mois dernier sur Community

      Bonjour à tous, Et bonne rentrée ! Comme chaque mois voici un résumé de ce qui s'est passé sur Community et dans l'actualité de Zoho en général. La grande nouvelle de mois d'Août est l'arrivée de la fonction Canvas : le premier studio de conception pour

    • Juillet : Un résumé de ce qui s'est passé le mois dernier sur Community

      Bonjour à tous, Le premier mois de l'été se termine, et si certain profitent d'un repos bien mérité, sur Community on continue à en apprendre toujours plus sur nos produits Zoho. Notre série sur Zoho CRM se réinvente avec la découverte de notre fonction

    • Community Digest - Résumé de mai 2021

      Bonjour à tous, Que s'est il passé en Mai sur notre page Community France ? En plus de nos articles Trucs et Astuces, vous avez été nombreux a réagir, nous poser des questions ou encore publier vos propres conseils ! Vos les différents sujets abordés

    • Recent Topics

    • Email Template Edits Not Saving

      I can make an edit, click save, and see the blue bar annimation at the top, but the edits don't actually save. Important, because my email templates are now broken and clients are receiving bad emails. Tried on Chrome, Firefox and IE.

    • Default Ticket View - Table?

      Guys, We mostly use the table view to queue tickets. Maybe I am missing it - but how can I set that view as 'default" for all our agents? Thanks JV

    • Can I have different users see different pick list values for Potential Stage?

      We have some users focusing on new business and others focusing on existing business, and they follow different sales processes/cycles, so we would like them to see different pick list values for Stage (eventually leading up to Closed Won/Lost in both cases).   And just to keep it interesting - some of these users will of course do a combination, so would need to see one pick list for their New business potentials and a different pick list for their Existing business ones.   Salesforce does this

    • Tracking Snippet not working in Zoho Marketing Automation!

      First off, the fact that you have to wait about 12-24 hours for every response is terrible. How are we supposed to conduct business? Second, we have been trying for several days to get the Tracking Code Snippet in marketing automation to work, to no avail.

    • Is there any way to send an Excel received by email to Dataprep?

      Every day I receive an email alert with an Excel file that I want to process through a Dataprep pipeline. To do this, I need to: -Save the file to disk -Open the pipeline -Run the pipeline -Update the source -Several clicks to select and open the saved

    • Read webpage - MSXML2.ServerXMLHTTP

      I have the following VBA script, put together from various sources (mainly zoho forum/help/support, so it once worked, I guess): private Sub GetListOfSheets() Dim url As String Dim xmlhttp As Object Dim parameters As String Dim html As String range("B1").value

    • Zoho Creator Form Search

      I'm new to Zoho Creator and so far i do like it but im shocked there seems to be no easy way to add a search function and/or navigation to there forms as this readily available in every platform i have used in the past. Anyway i have a form which i have

    • How to setup DKIM / SPF in Zoho Mail

      Hello there! I'm having a hard time understanding how to setup the TXT records for SPF and DKIM with Zoho Mail. I'm following the instructions here: https://www.zoho.com/campaigns/help/setup-spf-dkim.html Specifically, when it comes to the value for the

    • Mass update cant trigger a workflow?

      Hello there, Is this a normal Creator behaviour? In a report, if I manually edit each data row, it will pass those changes to all other reports. However, if I perform a Mass Update on a few data rows at once, the new data is not pushed to other reports.

    • search and Smart Bar both missing in Mail

      One of the users on my account does not have the search bar at the top right or the Smart Bar at the bottom left of the desktop Mail app. Any ideas how to get those back?

    • Let us add Lookup fields in the Blueprint Transitions

      We are unable to add Lookup Fields in the blueprint transitions in Zoho Desk, we wanted to make it a requirement for our workflow but since it's not available in the transition we cannot. The lookup field exists in the Layout: But it cannot be added/selected

    • Zoho Projects API Scope for Issue Attachments

      I try to download issue attachments via the API, unfortunately I always get the following error code when trying to download the file from the supplied URL: {"ERROR_MESSAGE":"INVALID_OAUTHSCOPE","ERROR_CODE":401} indicating an auth scope error. I've tried

    • How to fetch custom fields for time entries in Zoho Project API v3

      In the previous Zoho Projects REST API, we were able to retrieve custom field details for time entries, including picklist options, using the endpoint: GET /restapi/portal/[PORTAL_ID]/timesheetcustomfields In the new Zoho Projects API v3, we tried using

    • Zoho Survey Enhancements

      We love Survey. We use it a ton. It needs some enhancements. Maybe some of these are already on the roadmap? API - this is crucial. We have some complex surveys that take place and need to update records, trigger other functions/automations, etc. I would

    • Images Don't Display on Blog

      Hi, I've just posted a new blog entry, but regardless of format (png or jpeg) Images that display in Preview mode do not display on any browser in the published post.  I've not done anything different with this post than others regarding images, please advice. Thanks! Edit:  I've discovered that moving the image files from a my sub directory folder "Pics for Blog" to the top level of the "Files" folder on my site allows the images to display live.  This, even though my other blog posts are correctly

    • Checkbox Field Mapping Zoho Forms to Zoho Sign

      I have an application that will be filled out via Forms that I am mapping into a PDF Filler on Zoho Sign. I need to have a series of checkboxes mapped to the corresponding fields in Sign and I only see single checkboxes available via the mapping, though

    • Books P&L by Customer

      Lately, we have found that the Customer field filter for the Profit & Loss report in Zoho Books is no longer available. We have several projects with the same customer and look at the P&Ls by project AND by Customer (overall). Can you please add back in this field selection alongside the Project field to the P&L report filter? Thanks! -Gina

    • Sent mail sort by date disappeared

      Hello, We used to be able to sort the emails by date in the sent folder, but this feature has recently disappeared. Can we bring it back?

    • I cannot check out to Zoho People.

      When I tried to check out today, there's prompt that inhibits me to check out: To add entry in Attendance, log time for any of your jobs

    • Pricing Strategies: #2 Plan your Service Offerings using Plans

      Meet Harvey & Mia, hailing from the same Tech school, carrying the dream of setting up their own IT maintenance firm in their location. They drew up a clear business plan and put their business in motion on New Year's Eve. They had great reception right

    • Open a record to edit based on another form being edited

      Hi all, I am trying to edit a record based on another record being edited. It works out like this: When I create a Monthly_Update and then submit I open the Monthly_Levels form and pass the ID from the Monthly_Update to a field called mu. I want it to

    • Problem with signature on zoho survey

      Hello, I'm trying to export individual responses with signatures on zoho survey. But the signatures on some of my surveys are not exported as the original image, but as a generic image, same for all (screen joins). Is there a solution to have the signatures

    • Change in Zoho CRM API?

      Hello, I am using the Zoho API trough the PHP SDK v2.1 Since few days, I noticed that I have to change the way I pass the data to the API when I create, update, or upsert a record. Dates Before I was passing a PHP date object to "$record->addKeyValue(...)",

    • MTA - BAD IP reputation by outlook/hotmail

      Messages to Microsoft email servers are bouncing back due to poor reputation. Message: 4.7.650 The mail server [136.143.188.206] has been temporarily rate limited due to IP reputation. For e-mail delivery information see https://postmaster.live.com (S775)

    • QuickBooks Extension for Zoho CRM - Advanced Features -2025

      Hello Everyone, We’re happy to announce the latest version of our QuickBooks Extension for Zoho CRM, now officially live on the Zoho Marketplace! This release introduces one-click data sync, a user-friendly UI, enhanced performance, and a powerful set

    • Changing Department often causes the Firefox tab to freeze

      Title, it doesn't seem to happen with neither Opera nor Chrome. And even in Firefox, sometimes it just lets me change the department I'm in no problem, even to All Departments which is probably the most, like, resource heavy? But most of the time, the

    • Need to integrate Zoho Mail Mobile app with Zoho Meeting Mobile App for Android and Apple

      Hello Zoho Team, Please bring integration of Zoho Mail Mobile app with Zoho Meeting for Android and Apple Thanks

    • ¡Muchas gracias por participar a los Meetups de Usuarios de Zoho! Y Novedades del ecosistema Zoho

      ¡Hola Comunidad de Zoho en Español! 👋 Después de un breve lapso de tiempo, volvemos con una nueva edición de nuestro Community Digest, donde te contamos las novedades de los productos de Zoho en los últimos meses. Estas mejoras se centran en nuestros

    • Anyway to move mail from one account to another yet?

      Hello, Is there any way to move email from one mailbox account to another mailbox account in zoho yet? Thanks, Ryan.

    • Using a CRM Client Script Button to create a Books Invoice

      Hello, I need help handling error messages returned to my client script from a function. The scenario I have setup a client script button which is available from each Deal. This CS executes a crm function, which in turn creates an invoice based on the

    • Building Toppings #2 - Learn how to use Bigin's Developer Console to build toppings

      Hey Biginners, In our last post, we discussed what toppings are, why they're essential to extending Bigin's capabilities, and how the Bigin Developer Center serves as the starting point for building them. As a cloud platform, the Developer Center empowers

    • Links are incorrect when sent out

      I'm adding in hyperlinks into my eDM. When I send a test email, it's all correct. However, when I send out the eDM, all the hyperlinks jump up one space so none of the links are opening to the correct page. Why is this happening and how can I fix it?

    • Tip of the week #16 - Search and filter threads based on criteria

      Zoho TeamInbox lets you search and filter threads with any information that you have about the thread. You just have to input the criteria and Zoho TeamInbox will list all the threads that match the condition.   Firstly, there is a global search you can

    • Introducing recipient authentication via Stripe Identity in Zoho Sign

      Hi everyone! It's important to authenticate your recipient's identity before they access and sign important documents to ensure the highest level of compliance. Zoho Sign already helps businesses do this with various authentication methods: SMS OTP Email

    • Keep Converted Leads

      How do I keep the converted leads in the Leads Module after conversion (converting it to account, contact, deal). I want to add it in a converted stage in the leads module in order to get a report or dashboard and see all converted leads from my pip

    • Customizing Global Search Settings for All Users

      Hi Our team use the brilliant global search functionality within CRM many many times daily. But, we struggle with the out-of-the box columns that CRM gives you. We are always telling users to customize this look to more suit our business, to show the

    • Introducing Formula Fields for performing dynamic calculations

      Greetings, With the Formula Field, you can generate numerical calculations using provided functions and available fields, enabling you to derive dynamic data. You can utilize mathematical formulas to populate results based on the provided inputs. This

    • Tip of the Week #77– Stay informed of the activities happening in your organization

      Whenever a message is handled in Zoho TeamInbox, every action is recorded in the Activity Log. This ensures you always know what’s happening across your teams and inboxes. To access it, simply click the Audits icon on the left pane’s top bar after logging

    • Zoho Logs - Not seeing logs since 30 Nov

      Hi, we have a few functions running, I am testing some new ones and noticed that although I can see executions, I cannot see any logs, even when the first line on the functions is a log. I reviewed some existing functions, one of which is invoked on a

    • Workdrive MS Office integration

      Have installed subscribed version of Zoho WorkDrive VSTO runtime not found is the error when I try to install Zoho_WorkDrive_For_Office Unable to open work files in Excel and Word Urgent, since I have migrated all my OneDrive files to work drive already

    • Next Page