Ask the Experts #1: A live Q&A with the Zoho Sheet team

Ask the Experts #1: A live Q&A with the Zoho Sheet team

Hello all,

We're excited to launch our "Ask the Experts" community learning series for Zoho Sheet on Wednesday, September 4th, 2019. This series will allow users to interact with the team behind Zoho Sheet in real-time and ask questions about various aspects of Zoho Sheet and use cases.




Ask the Experts #1

Topic: Everything about Zoho Sheet

Date: Wednesday, September 4th, 2019 

Time: 6:30 a.m. to 11:30 a.m. PDT


This first live Q&A session will feature six product experts from the Zoho Sheet team answering your questions and discussing feedback on all things Zoho Sheet. For five hours on Wednesday, September 4th, comment on this post with all your questions on formatting, functions, charts, integration, mobile apps, artificial intelligence in Sheet, and much more.


 

Note: Unable to view the comment box? Sign in using the option on the top-right corner to view and start posting.

​
Already have a question in mind? Drop it as a comment below and our experts will answer it during the live session.

See you all in the live session!





      • Sticky Posts

      • Ask the Experts #1: A live Q&A with the Zoho Sheet team

        Hello all, We're excited to launch our "Ask the Experts" community learning series for Zoho Sheet on Wednesday, September 4th, 2019. This series will allow users to interact with the team behind Zoho Sheet in real-time and ask questions about various aspects of Zoho Sheet and use cases. Ask the Experts #1 Topic: Everything about Zoho Sheet Date: Wednesday, September 4th, 2019  Time: 6:30 a.m. to 11:30 a.m. PDT This first live Q&A session will feature six product experts from the Zoho Sheet team answering

        • Recent Topics

        • 5名限定 課題解決型ワークショップイベント Zoho ワークアウト開催のお知らせ （12/19）

          ユーザーの皆さま、こんにちは。Zoho ユーザーコミュニティチームの藤澤です。 12月開催のZoho ワークアウトについてお知らせします。 ※定員に達したため、受付を終了しました。 ━━━━━━━━━━━━━━━━━━━━━━━━ Zoho ワークアウトとは？ Zoho ユーザー同士で交流しながら、サービスに関する疑問や不明点の解消を目的とした「Zoho ワークアウト」を開催します。 Zoho サービスで完了させたい設定やカスタマイズ、環境の整備など……各自で決めた目標達成に向け、 他の参加者と同じ空間で作業を行うイベントです。先輩ユーザーや他の参加者と意見交換をしながら集中して作業に取り組むことが可能です。

        • Feature Request: Search in the PC client. Some thoughts about the search.

          Hi all. I'm really excited to start using Zoho Notebook, but I'm missing some of the search capabilities on my desktop. There are also some thoughts on improving search in general. Search is very important to me, without it it is difficult for me to use

        • Whatsapp reply not reflected under Tickets for offline agent

          Hi, We are encountering a situation where WA response from customer is not reflected under tickets (if the agent handling the case previously is not active due to off day/ MC). The ticket will remain in the offline agent's queue until agent is back to

        • KB Templates

          * It would be nice if Zoho can provide users an option to create custom templates for KB articles. Also, it would be nice as well if the users can have an option to 1.) select a default template and 2.) declare default tag/tags, for KB articles created through Ticket's resolution.

        • Email signature not being included if user creates ticket / sends email

          When I create a ticket (send email), the signature doesn't appear to be added to the ticket. Can you confirm if this is the case? It would obviously be useful to include the user's signature even when sending a client an email and not only on replie

        • Missing Folders on iPhone Zoho Mail

          Under mailboxes on my iPhone, I don't have an inbox, sent folder, deleted photo, etc. See pics.

        • Error 403: Forbidden When Updating Email Signature via API

          Hi Zoho Desk team, First, congratulations again on the excellent Zoho API. But, I’m encountering an issue while attempting to update an email signature via the API. Whenever I make a request to update the signature, the response returns an HTTP 403 Forbidden

        • Apply Credit Note Automatically

          We need the ability to apply open Credit Notes toward invoices generated by recurring invoice as the first, priority payment. This should be an option that we can enable/disable in the recurring profile and/or the Credit Note. Other invoicing systems can do this. I'm not sure why Zoho Invoice doesn't have it. Here's an example for a Recurring Invoice... If a customer has open Credit Notes, and a saved credit card set for auto-pay, once an invoice goes out, the credit balance gets automatically applied

        • Unable to Download CRM Contact Data: WorkDrive Integration Issues

          ## Problem Description We need to let users download contact information from CRM as CSV files to their local computers. Since we couldn't implement a direct download option, we're trying to use WorkDrive as a workaround - but we're encountering issues

        • Select CRM Custom Module in Zoho Creator

          I have a custom module added in Zoho CRM that I would like to link in Zoho creator.  When I add the Zoho CRM field it does not show the new module.  Is this possible?  Do i need to change something in CRM to make it accesible in Creator?

        • Not able to change colors help center

          Hi. How can I change the orange color in the help center? You can change everything besides this font color And how can I remove the part on the bottom?

        • What is syntax to call creator function (or trigger a creator workflow) from CRM deluge?

          What is syntax to call creator function (or trigger a creator workflow) from CRM deluge?

        • Send Whatsapp with API including custom placeholders

          Is is possible to initiate a session on whatsapp IM channel with a template that includes params (placeholders) that are passed on the API call? This is very usefull to send a Utility message for a transactional notification including an order number

        • Increase Round Robin Scheduler Frequency in Zoho Desk

          Dear Zoho Desk Team, We hope this message finds you well. We would like to request an enhancement to the Round Robin Scheduler in Zoho Desk to better address ticket assignment efficiency. Current Behavior At present, the Round Robin Scheduler operates

        • I'm getting an "Invalid_scope" error, even though I used an access token generated with the correct scope.

          I'm getting an "Invalid_scope" error, even though I used an access token generated with the correct scope. Here’s what I did in Postman: Generated the code to create an access token using the following URL: https://accounts.zoho.eu/oauth/v2/auth?scope=ZohoCampaigns.contact.UPDATE&client_id=<client_id>&response_type=code&access_type=offline&redirect_uri=https://1882-2-26-193-161.ngrok-free.app

        • Separate One-Time Mentions from Ongoing Ticket Following in Zoho Desk

          Dear Zoho Desk Support Team, We are writing to request an enhancement to the mention functionality within Zoho Desk. Currently, when an agent is mentioned in a ticket, they receive notifications for all subsequent activity on that ticket, similar to being

        • Projects Multiselect API

          Having troubles setting a mutli select field via API. updateMap = map(); updateMap.put("UDF_MULTI1","picklist_id1,picklist_id2"); updateProjectRes = invokeurl [ url :"https://projects.zoho.com/restapi/portal/XXXX/projects/" + projectID + "/" type :POST

        • Mass update Accounts in Zoho Desk

          We used the integration feature to bring in all of our accounts from Zoho CRM. While all of the names and links are in place, on the Zoho Desk side the email, phone, website, and address fields are blank. By going into each account I can select "Update

        • Vivaldi will not open the Zoho Mail app when I click a email link in the browser

          I'm running Vivaldi on Arch with the Plasma desktop and have under default applications Zoho Mail set as my default email client. Whenever I click a email link in Vivaldi I get the below when it should be launching Zoho. Any ideas on rectifying this issue?

        • Digital publisher

          Kinetic Digital Publisher provides comprehensive digital publishing services, including eBook creation, formatting, cover design, and marketing. We help authors publish and promote their work across online platforms with ease.

        • Client Script - mapping data from different module

          Dear ZOHO Team Firstly I need to describe the need - I need to have data from Contacts module based on lookup field - the 5 map limit is not enough for me because I have almost 20 fields to copy So I have decided to make a Customer Script - and from unknown

        • Time Zone Correction with Daylight Savings Time

          Hey, I'm writing a series of reports where the source data is synced from an external source which stores the date/time information in GMT, but I want the reports to be in local time. Now, I understand there is the CONVERT_TZ function which allows me

        • Load form in iframe without header

          I am trying to load a form into an iframe without the header, but I am not having any luck. I am using openUrl() to load the iframe with the form URL and zc_Header set to false, e.g. #Form:Add_Case?zc_Header=false but it is still loading the header. Any

        • Filter embedded report

          How to filter embedded report in a page, below code is not working. dateField => startDate & dateField=< endDate The report should print on page containing records from startDate to endDate. params='zc_Header=true&amp;Service_Date__gte=<%=startDate%>&amp;Service_Date__lte=<%=endDate%>'

        • Creator Simplified #5: Set file upload restrictions in Zoho Creator

          Hey Creators, Welcome to the next post in the Creator Simplified series. Today, we’ll explore how to implement file upload restrictions to limit user submissions to specific file types. By implementing an allowed list for file uploads, you can optimize

        • Field Type: Address, Change District/State to Dropdown with picklist??

          Using the Address Field type, is there a way to make the District/State field be a dropdown with a picklist so the users can select rather than type the state name every time? I know this can be done if I use a drowdown field for the State (or entire address information), but that isn't as tidy as using the address field type. I apologize if this is a duplicate. I posted this question the other day, or so I though. Can't find that post.

        • cutomized fields are not showing up in zoho creator from zoho crm

          We have customized fields in zoho crm under accounts module like "Last production upgrade" --> This field is a date. When created a solution in zoho creator i couldn't find any of the customized fields. Would you please help me on this matter? Thanks

        • How to Add Bulk Data in Zoho Creator Forms Using Deluge Without Exceeding Execution Time Limit

          I have a database form with a column named 'Product Name' containing 8000 values in a Zoho Creator form. In another form named 'Returns Data,' I have a column with the same name, 'Product Name.' How do I add these 8000 values to the 'Returns Data' form

        • Open New Free Zoho Account

          Hi Team, Do you guys offer a free email hosting? I do have a domain already. If yes, what is the process to open the new account? Thanks,

        • 554 5.7.1 : Recipient address rejected: user info@intimspace.de does not exist

          554 5.7.1 : Адрес получателя отклонен: пользователь info@intimspace.de не существует I can't send an email to Google at info@intimspace.de. An error comes. I entered everything correctly in DNS https://zohomail.tools/#domainDetails/intimspace.de/ALL

        • Emails going back unread

          Hi all, When in Zoho mail - when I recieve a new mail it puts back all emails read that day back to unread - I then have to go back through and open all emails I have already read! Gets very annoying... Any idea on the bug fix?

        • Automatically updating field(s) of lookup module

          I have a lookup field, which also pulls through the Status field from the linked record. When the lookup is first done, the Status is pulled through - this works perfectly. If that Status is later updated, the lookup field does not update as well. As

        • Constraints on Tasks

          We have a use case where we have certain fixed date tasks and need to schedule predecessor tasks around these. Predecessor tasks need to be completed with a lag before the fixed date. We should be able to schedule the start and end date for predecessor

        • Moving Project Dependencies Not Moving Precedessors

          Most of the time we want to base our start dates around an event that is in the middle of the project template. If I set a bar up at the date we want it, it doesn't move the predecessors up. Is there a way to change this? eg. there is no point starting

        • Can you set task due dates to be "x" days before the milestone?

          We have a milestone set as the date of our first event. All of the tasks need to happen in increments prior to the milestone event. Is there a way to configure this without having to set up each task due date? Thanks!

        • Change script to add fields

          Hi, I have a custom function (writen by a different implementation company in the beginning) which I would like to edit to add a different field as well. Can't get it to work on my own though. - The script now adds the address fields to a new quote (needs

        • Integration between Zoho CRM and Zoho WorkDrive

          I'd like to search Zoho for an invoice I've added as an attachment (pdf) to an account. The name of the invoice is 1388-advertiserx-July.pdf - but I can't find it using the search function for any of these terms: 1388 1388-advertiserx 1388-advertiserx-July.pdf

        • Default ticket template in helpcenter

          Hello, I have a web form and a ticket template created. How can I make that my default ticket template? If an user clicks New ticket or create a ticket, I want that template to be the default one. Thank you for the time and info.

        • Expanded data-capturing capabilities with enhanced tabular sections

          We are thrilled to announce an update to Zoho Recruit that brings even more flexibility and customization to your recruiting process. With the addition of 10 new field types to the tabular sections, you now have the power to enhance your tabular sections

        • Integration of Business Hours in Email Templates

          Dear Zoho Desk Team, We would like to propose a feature enhancement to Zoho Desk that would greatly improve the utility of the Business Hours settings and streamline communication with our clients. Feature Request: Integration of Business Hours in Email

        • Next Page