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

    • Meet Canvas' Grid component: Your easiest way to build responsive record templates

      Visual design can be exciting—until you're knee-deep in the details. Whether it's aligning text boxes to prevent overlaps, fixing negative space, or simply making sure the right data stands out, just ironing out inconsistencies takes a lot of moving parts.

    • Zoho Subform Workflows onAdd of Row

      Suppose I have a form with attached workflows onLoad. If I use the form as a subform, will it inherit the workflows or do I need to create new ones onAdd of row?

    • Super Admin removal

      I brought a sub, and I gave the Super admin rights to a person who is no longer with us, so I need to change, and I need to make myself the Super admin

    • Employees in Leave Policy exceptions

      In the Leave Policies we should be able to add specific employees to the exception list So it will be like All Employees except A,B,C in the exception list, currently we can only add departments etc

    • Better Notes Commenting

      Hi, I'd like to suggest better collaboration tools for NOTES. The current notes section for Accounts, Contacts and Deals is not ideally suitable for any degree of communication or collaboration. When responding to a note, there is no ability to leave

    • Formula field with IF statement based on picklist field and string output to copy/paste in multi-line field via function

      Hello there, I am working on a formula field based on a 3-item picklist field (i.e. *empty value*, 'Progress payment', 'Letter of credit'). Depending on the picked item, the formula field shall give a specific multi-line string (say 'XXX' in case of 'Progress

    • Exporting Templates

      I have just spent 2 hours creating a project template for a Netsuite configuration, and want to share it with other Zoho Projects users - who have a different account. Is there any way to do this?

    • Power of Automation:: Streamline Associated Teams based on the Task Owner update.

      Hello Everyone, A Custom function is a user-written set of code to achieve a specific requirement. Set the required conditions needed as when to trigger using the Workflow rules (be it Tasks / Project) and associate the custom function to it. Requirement:

    • No Response from Zoho Support in 8 Days - Typical?

      I have a couple of issues I'm trying to work through. Initially, I was getting support from support@zohofsm.com, but I have not received a response in 8 days (11 on another question). Is this typical? Can I pay for support? For context, I am not spamming

    • Add QUOTE OWNER profile image to a Quote Template

      I can add their email address.. phone number, DOB. I need to add a users profile picture so when they assign a template to a quote they own it adds their picture to the cover page. I've tried hacking a solution together but there has to be an easier way.

    • Email Integration - Zoho CRM - OAuth and IMAP

      Hello, We are attempting to integrate our Microsoft 365 email with Zoho CRM. We are using the documentation at Email Configuration for IMAP and POP3 (zoho.com) We use Microsoft 365 and per their recommendations (and requirements) for secure email we have

    • Elevate your CX delivery using CommandCenter 2.0: Simplified builder; seamless orchestration

      Most businesses want to create memorable customer experiences—but they often find it hard to keep them smooth, especially as they grow. To achieve a state of flow across their processes, teams often stitch together a series of automations using Workflow

    • Zoho Connections Desk API relative URL PATTERN_NOT_MATCHED

      While i am trying to do this: async function fetchTicketsFromDesk(timeFilter = 'current_month') { try { const response = await ZOHO.CRM.CONNECTION.invoke("desk_connection", { url: "/api/v1/tickets", method: "GET", }); const data = response.details ? JSON.parse(response.details)

    • Zoho CRM - Custom Views for Portal Users

      I'm looking for an option to customise custom views for portal users in CRM. It would be great if "portal user" was a permission on custom views.

    • 【参加無料】10/17(金) 東京 ユーザ交流会 Vol.3 参加登録 受付開始！

      ユーザーの皆さま、こんにちは。コミュニティチームの藤澤です。 10/17(金)に、東京・新橋で「東京 ユーザー交流会 Vol.3」を開催します！ 今回のユーザー事例セッションのテーマは、「Zoho Flowを活用した他社の決済サービスとの連携事例」です。 さらに、Zoho Flowに限らず、Analytics や Campaigns などの多彩なZohoサービスの活用方法について、豊富なご経験をもとにご紹介いただきます。 また、Zoho社員セッションでは、Zoho CRMを活用して日々の営業業務を効率化する具体的な事例をお話しします。業界を問わず、幅広い方にご参考いただける内容となっています！

    • Zoho Meeting Plug compatibility with newer versions of Outlook

      Documentation states that the zoho meeting plug in for outlook is only compatible with versions up to Outlook 2019 What is available to users of more up to date versions of outlook/office 365?

    • Getting Attachments in Zoho Desk via API

      Is there a way to get attachments into Zoho Desk via an API?      We have a process by which a zoho survey gets sent to the user as a link in a notification.    The survey has several upload fields where they can upload pdf documents.    I've created

    • Introducing Zoho's own SMS gateway

      We're thrilled to announce the launch of our own SMS gateway feature within Zoho Marketing Automation! This new feature enables seamless SMS campaign management alongside your email marketing initiatives, providing a more integrated and efficient way

    • Embedding in Desk articles

      We would like to embed documents in our Desk articles. When we use an iframe for the embed, we get scrollbars and a frame border. Neither of those is acceptable. I've spoken with the Desk Support team about what we want and they tell me that it cannot

    • Zoho CRM button to download images from image upload field

      Hello, I am trying to create a button in Zoho CRM that I can place in my record details view for each record and use it to download all images in the image upload fields. I tried deluge, client scripts and even with a widget, but feel lost, could not

    • Mass Update Contacts In Zoho Campaigns

      Is there a way to mass update contacts in zoho campaigns? I want to be able to change the content of a field for a few hundred contacts, and can't go through all of them individually.

    • report showing assignment type

      Hi, We've created a number of workflows to allow us to auto assign tickets to agents based on keywords and other criteria. I'm struggling to create a report that would show me what is the percentage of tickets that are assigned automatically via workflows

    • Option to Disable Knowledge Base Section in Feedback Widget Popup Hello Zoho Desk Team

      Hello Zoho Desk Team, How are you? We are actively using Zoho Desk and would like to make more use of the Feedback Widget. One of the ways we implement it is through the popup option. At the moment, the popup always displays the Knowledge Base section,

    • Placeholders in Ticket Templates

      We should be able to use placeholders in ticket templates. When we create a new ticket, our description field is shown to the client in the email they receive.  It would be very handy to be able to personalize that description field in our ticket templates to pull in the name of the client that the ticket is for. Using them in the subject field as well, so we can auto populate Account Names, etc. 

    • when the record is created the tag want to Show as Opportunity how i achive this using Deluge Script

      In the quotation i have the work flow schedule for create opportunity record in the module , on that time the quotation tag select as opportunity created. How i achive this using Deluge Script . this like i want to Do tag1 = Map(); tag1.put("name","Nurturing

    • Delete a channel

      I need delete a channel in tickets.

    • Copy / Duplicate Workflow

      I have workflows setup that are very similar to each other. We have a monitoring system watching servers, and all notifications - no matter what client it is about - will come from a  noreply@ address which is not very helpful in having it auto assigned to the right account. I have setup a workflow that will change the contact name of the ticket (currently it would say noreply@) to the correct customer which is based on the subject line, as that mentions which server the alert it is about. I need

    • Subtasks don't update parent task's times

      Hi there: I've recently upgraded to premium and check that subtasks completion % don't update the proportional completion of the parent tasks related to it.  We've been challenging with the problem of having to update twice or sometimes 3 times the completion of the related tasks. I've seen posts similar to this, of 3 years old.  Is there any roadmap for making this happen in a future release? Thanx César Ratto Lima, Perú.

    • Should I Use DMARC?

      When I configure Zoho Mail's DMARC settings, it's mandatory to fill in the RUA and RUF (Aggregate notification email address*, Forensic notification email address*) addresses. When we enter an email address in these fields, we receive reports from the

    • Mail ToDo & Tasks Webhooks

      Our company uses Zoho ToDo inside Mail to manage our tasks. When I create a task and assign it to a team member it does not notify them unless I add a reminder via mail. I'm trying to create a webhook for when a task is created to send a cliq message

    • What is Resolution Time in Business Hours

      HI, What is the formula used to find the total time spent by an agent on a particular ticket? How is Resolution Time in Business Hours calculated in Zohodesk? As we need to find out the time spent on the ticket's solution by an agent we seek your assistance

    • Can't upload attachments.

      I can't upload attachment in Zoho Mail.

    • Tip #44 – Get Deeper Insights with Zoho Assist’s Custom Reports – ‘Insider Insights’

      In today’s fast-paced IT environment, having a clear view of your remote support activities is more important than ever. Zoho Assist’s Custom Reports feature gives IT teams the ability to generate tailored reports that provide actionable insights and

    • Message "...does not support more than 100 distinct values..." WHY????

      I get this message on one of my reports: Sorry, Zoho Reports currently does not support more than 100 distinct values in columns. 'Account Name * Sum(Amount),Count(Amount Tier)' contains more than 100 distinct values.  Possibly, you can apply filter to reduce the number of distinct values in 'Account Name' or drop the 'Account Name' field in Rows. I want to list all ACCOUNT NAMES (about 500) with SALES BY ACCOUNT.  What is blocking this?

    • Need Easy Way to Update Item Prices in Bulk

      Hello Everyone, In Zoho Books, updating selling prices is taking too much time. Right now we have to either edit items one by one or do Excel export/import. It will be very useful if Zoho gives a simple option to: Select multiple items and update prices

    • Let's Talk Recruit: Super-charge hiring with Zoho Recruit add-ons

      Welcome back to our Let’s Talk Recruit series! This time, we’re diving into something that might seem like a small upgrade but has a huge impact on recruiter productivity: Zoho Recruit add-ons. Think about how much of your day is spent in your inbox or

    • Vendor Signatures Needed for Purchase Orders

      Hello everyone, We have a unique requirement that necessitates that Vendors & Suppliers formally acknowledge our Purchase Orders upon receipt. I was hoping that there would be an option to do so in Zoho Books, but that does not appear to be the case.

    • Is there an API to "File a Ticket" in Desk

      Hi, Is there an API to "File a Ticket" in Desk to zoho projects?

    • Store "Sign in with Google/Microsoft/GitHub etc." details

      Quite often now, users are using a sign-in provider like Google or Microsoft to sign into various apps and services. It would be great if Vault could remember which providers you use for each website and sign you in with that provider instead of a username

    • Critical Issue: Tickets Opened for Zoho Support via the Zoho Help Portal Were Not Processed

      Hi everyone, We want to bring to your attention a serious issue we’ve experienced with the Zoho support Help Portal. For more than a week, tickets submitted directly via the Help Portal were not being handled at all. At the same time no alert was posted

    • Next Page