Did you know you can actually sort data dynamically using Array Formulas? Earlier this week, we introduced the powerful new functionality of Array Formulas. And today we’re highlighting a unique way to sort your data using this functionality.
Have a look at the two spreadsheets embedded below. The first example shows data gathered from NYSE, including the current stock price, stock price at previous day close, and % change from previous day close, using the Stock Formula for various stock markets like NYSE-100, NASDAQ, etc. The second table in each sheet contains the list of companies sorted in descending order of the price change using Array Formulas:
Similarly, this second example displays matches from a Cricket tournament by taking data from the ‘Match Details’ sheet and making use of Array Formulas:
This is just one way to creatively use Array Formulas.…
would like to share relevant useful content over email to keep their
subscribers engaged and happy. However, no one likes being branded as a
spammer when they only intended to send genuine emails to their
subscribers. Yet, a lot of people opt to receive their emails and later
mark them as spam. Not good. Now, to take
care of this, Zoho Mail provides a feedback loop service to ESPs and
senders sending emails to Zoho users that helps them stay clean,
maintains IP reputation and improves email deliverability. This can
indeed be a seamless, effortless and simple task.
If you are an ESP or a sender sending emails from your own IP, register
yourself with Zoho’s feedback loop service, and we will show you how to
stay away from unhappy subscribers and how not to bother them, once they have
indicated disinterest in your emails.
You must be thinking, now, how does this work with Zoho?…
Tired of frantically trying to look up the most recent request sent by a customer (who is on hold!)? Well, we have a solution for you, Zoho Support’s latest feature – Zoho PhoneBridge.
This feature connects your telephone system (PBX) with your Zoho Support account. You can receive notifications about incoming calls and outgoing calls. When you receive a call, key details about the customer appear in a popup on your screen. You can view the customer’s name, e-mail ID, telephone number and 4 of the recent open requests belonging to them.
The key features of Zoho PhoneBridge include the following:
- Manage your incoming and outgoing calls
- View the details of a contact or account when you receive or make a call
- Associate calls with tickets
- Enter the time spent on each call automatically
- Generate reports to view the amount of time spent, by support representatives, on each call
- Create multiple Zoho PhoneBridge groups to enable better customer support
Supported PBX Systems
The PBX systems that we currently support are:
- Asterisk 1.4
- Elastix 1.6
- Trixbox 2.6
This document explains how to enable the PhoneBridge feature in Zoho Support.
“In Quick – out quick, nobody gets hurt
” – That captures what we set out to do with our new CRM. Thanks, Gary, for noticing it
But we must admit that was not always the case. Our old UI was pretty bad. Why? And most importantly – why and how did we fix it?
Well, traditionally we focused on the MANAGEMENT side of Sales. We were making CRM Administrators and VPs of Sales happy. Their goal is to automate the entire sales process and also get insight into their sales funnel! With our features around Customization, Role Based Security, Workflow Management, Web Forms, Reports and Dashboards and so on, that was very easy to do.
For example, this is the kind of feedback we were getting from THAT audience.
@sarahschaeff: Loving the flexibility & functionality in @zohocrm
So we were making sales execs and CRM admins happy.…
Zoho Creator makes building on-the-fly business apps a breeze. And today it gets even better: Introducing subforms!
Zoho Creator users are familiar with the many fields you can include on a form. For example, we’ve had a Look Up field for a while. Lookup fields are useful when you want to associate data in one form with a single piece of data in another form.
But what happens if you want to associate one record in a form with multiple records in another form? For example, what if you have an application of students and you want to keep track of the classes they are taking? Students will be attending more than one course. That’s when subforms become very useful.
In this case, you can create a form that holds the student’s general details (i.e Name, ID number, etc), and another form that holds the course details (Course Name, Instructor, etc).
Today we’re taking online productivity software to the next level. Everyone else focuses on making reduced-functionality online tools. That’s not the path we’ve chosen. We want to make the best online tools. We want to make them even better than their desktop counterparts. And while Zoho Show is currently the best online presentations editor available, we are never completely satisfied.
So we’ve been working for a long time on the next release of Zoho Show. We have made it easier for users to create visually appealing presentations. We focused on making the whole process painless and effortless, and we wanted to make sure you can deliver your presentations anywhere. We’re excited to unveil the beta version of Zoho Show 3. And while there are still some kinks to iron out, it is at a stage where we’d like to open it up for people to try it out and give us some feedback.…
If you’re a Zoho Sheet user, you’d be thrilled to learn how your Spreadsheet experience just got better! That’s right, Zoho Sheet just became more powerful with these two new functionalities that make complex sheet functions simpler: Array Formulas and Named Expressions. In addition to these features, we have also enhanced our STOCK() formula.
Here’s an overview of these helpful new additions:
Have you ever tried finding cells matching a particular pattern in your spreadsheet? Such as, finding the average of numbers that are greater than zero within a range of cells?
An array formula is a formula that does just that; perform multiple calculations on one or more items in an array. So you can do things which are generally not possible through the regular formulas.
For example, the Stock Portfolio spreadsheet embedded below uses Array formulas to fetch the ‘current price’ and ‘% change’ from Yahoo Finance.…