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. Have you used Array Formulas in a unique way? If so, do share it with us.
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?
- You send an email to a Zoho user on behalf of your customer/user
- Recipient marks your email as spam
- You receive a notification with a report in ARF (Abuse Reporting Format)
Below is the typical work flow of the Zoho feedback loop service.
Benefits using Zoho’s feedback loop service:
- Maintains IP reputation
- Improves email deliverability
- Improves overall quality of user subscription
Zoho’s feedback loop service helps
ESPs and other senders stay clean by reporting whenever their emails
to Zoho users are marked spam. We report complaints to users (email
senders) with a “copy of the message” to help senders identify &
relieve unhappy subscribers.
subscribers can be a major cause for high spam complaint rates.
Often, users are mistaken during a sign up process and end up marking
your email as spam. We here at Zoho can help you avoid these hiccups.
makes utmost sense to keep you and your organization registered and
safe, in order to avoid being blocked by an ISP. What’s more, Zoho’s feedback loop service is free! I definitely want to safeguard my
organization’s IP reputation, wouldn’t you?
Refer here to find answers to some basic questions.
Get started by clicking https://fbl.zoho.com.
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.
- 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
- Asterisk 1.4
- Elastix 1.6
- Trixbox 2.6
This document explains how to enable the PhoneBridge feature in Zoho Support.
We would like to hear what you think about our new feature. Write to us at firstname.lastname@example.org or post a comment below.
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
By talking with our users, sales & marketing folks – the people who cannot live without a CRM system on a day-to-day basis – we learned what should have been obvious since the beginning:they want to sell more and spend very little time inside their CRM. To be more productive is all they wanted. Consider your typical sales rep. Their focus is to qualify more leads, close more deals and meet the monthly sales targets. They don’t like spending time inside the CRM system and updating status.
So then we asked ourselves questions like:
- How do Sales people behave inside a CRM system?
- What do they expect a CRM system to offer?
- What are their CRM usage patterns?
And then we understood. We needed to provide a balance between Automation and Productivity. Our feature set was good enough to automate any business, but we had to re-design the user interface of Zoho CRM for easier navigation and data access. It should be a CRM system that helps Sales Reps to focus more on managing their customer relationships and less on CRMing.
After 9 months of iteration and iteration, the outcome of our efforts is almost ready:
So we were, understandably so, elated when we saw Gary’s tweet. We think we’re on the right track.
Here are some of the highlights of the new design:
The Setup page is better organized with all links grouped under relevant headings. It’s easier to find what you are looking for and there’s no more scrolling.
The Business Card View. Goodbye Scrolling!
When clicking a contact, you’ll find the basic information at the top of the page. So, if you have a call with a contact, you do not have to hunt for details like the phone number or the account name. It’s right where you can see it.
Faster access to customer conversations
Right below the Business Card view is the Notes section – which you can get to quickly during a call. And we made it easier for sales reps to enter notes. And from our very own, internal experience, usage of notes inside CRM sky-rocketed.
Those are just three examples of the many changes we made.
The public launch of the New Zoho CRM is not very far away. Meanwhile, you can start working on the new CRM, right now. We’re still fixing some details – so please let us know your feedback. Please take into account that you’ll be accessing your live DATA but with a different UI. Any changes that you make will be reflected on your “other” account – it’s just the same data, just looking at it through a different – and hopefully better – window.
Check out our new CRM today. Head over to
Stay tuned for more!
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.
We would love to hear what you think of this latest addition to Zoho Creator.
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.
Zoho Show is the best online productivity experience anyone has ever delivered in a browser. I’d tell you what’s new in this release vs our current one – but everything is new here.
Here’s an embedded presentation about Zoho Show 3 we created with -you guessed it right!- Zoho Show 3.
You’ll be able to see an embedded presentation that showcases some of the new features. You can also click on Try Now to go the editor and play around with it. Please remember that you won’t be able to save any changes or work that you do in the new editor – we’re still in beta! Finally, you can also sign-up to be notified when we release Zoho Show 3 into production.
If you’ve read this far, you’ve read more than enough. You’d be better off just going and trying it!