Spreadsheets are helpful for many things, and one of those uses is project/task management. Google Sheets is one of the most accessible and valuable spreadsheet services out there, and now it’s getting a little friendlier for task management purposes, too.

Google has announced that Sheets will support drop-down bullets. They’re like the drop-down bullet points commonly used in good task management services like Asana and Airtable. You can add drop-down pellets to cells in your spreadsheet and assign different colours that serve as an additional visual indicator, letting you know the status of something at a glance.

The workflow for creating these chips and all other data validation rules have also changed. All regulations made in a specific Sheets tab can now be viewed, edited, and added to new rules in a sidebar view. According to Google, this workflow is now similar to creating rules for named ranges, security ranges, and conditional formatting.

It’s important to note that Sheets already support drop-down items in menus. Instead, it seems to complete creating these drop-downs and adding the “chip” colour visual; at this point, it was pretty much just plain text.

This feature is rolling out and should be available in all spreadsheets within the next 15 days.

What are people tabs?

People Chips is part of the new direction Google Workspace is taking with the Smart Canvas initiative. They show useful information about your contacts when you hover over them, including contact information, your recent interactions with them, calendar events, and easy ways to contact them.

While very similar to Smart Bullets in Google Docs, they have limited functionality. You can only add people or groups using the People Chips option. One significant thing to note is that they don’t inform the person when you enhance them to the sheet. That’s not your goal. Maybe Google will add more features in the future. At least not yet.

For example, you can also format the bullets for people by changing the font colour, size, and style.

How to insert people bullets in Google Sheets

Using People Chips on Google Sheets is as easy as eating chips. You can easily add people bullets to Google Sheets in just a few taps using the menus or by typing “@” in the cell.

 1. Insert by Typing @

First, choose a blank cell and category the @ symbol. A drop-down menu will appear as soon as you type the @ sign, showing people you’ve recently interacted with in Google Workspace.

Enter the person’s name or the first few letters of the person’s name that you want to add to person tokens to narrow your search. Then select a communication from the drop-down list below PEOPLE or GROUP.

2. Paste from the menu

The second method to insert personal cards is to click on the Insert menu and select the Personal card option.

You can now enter the first letter of the contact’s or their full name and select the connection from the drop-down list.

And your chip will be secure in the selected cell.

3. Turn emails into personal cards

You can also convert the entered email address to a personal chip.

First, enter the email address in a cell where you want to insert a person bullet.

Then right-click on the email address and select the “Convert to personal chip” option.

If you have a list of email addresses in a column that you want to convert to people’s bullet names, select the entire column, right-click on it, and choose the “Convert to People Bullet” option.

Now the personal chip is placed in the selected cell(s).

Note: Cells with values ​​other than an email address will not be converted to People Chips.

Sometimes, even when trying to convert an email address to a Contacts chip, you see an error similar to this: “Cell B11 contains an invalid email”.

In this case, open the Google “Contacts” application and click on the “Create a contact” button. Then enter the required information in the contact’s profile and save it.

After that, try again to insert the people chip into the people chip.

How to use people bullets in Google spreadsheets

If the contact has a Google profile (Google Contacts), you will only see the person’s name; Otherwise, you will only see your email address in plain text. Once the person chip is placed, please hover over the smart chip to view contact information such as email address, phone number, organization, and how to contact them.

On the intelligent chip, you have the options “send an email,” “send a message,” “start a video call,” and “schedule an event” to connect with the person directly from the phone. On the contact’s smart card, click “Open Detail View” to see more details, such as B—your recent interactions with them on Google Workspace.

Also, once you tag someone in a document, you’ll see a dialogue in the corner of the window stating that you don’t have access to the document. Click the “Share” button to share access to the document with the tagged person.

How to Use People Lists in Google Sheets

Insert person tokens into Google Sheets to tag a person in a cell to see their contact information and connect with them instantly.

People Chips is a new feature introduced in Google Sheets in late 2021. It allows you to highlight someone from your Google Contacts list in a cell and see their contact information when you hover over their name. This feature is similar to the intelligent chip in Google Docs, which lets you select people, emails, groups, and more when you type the @ symbol.

Let’s joint in and realize how to insert and usage People Chips in Google Sheets. Hover over the built-in people chip (name). You’ll see important information about that person, including title, location, and contact information (email address, phone number, etc.). Adding people bullets can be very useful for sending emails or messages, starting video calls, scheduling meetings, and assigning tasks to people right from the Google Sheets cell.

How to turn off people bullets / reset bullets on email addresses in google spreadsheets

If you no longer want the Smart Chip and want to convert the People Chip into an email address, you can easily do this in two steps.

Select the cells containing the person markers. Next, right-click on it, navigate to “Show more cell actions,” and select the “Remove smart chip” option.

And people bullets are now displayed as regular email addresses in the cell.

That’s it. People Chip’s functionality is pretty limited at the moment, and there’s not much you can do with it.

Also read: Web-based Printing Services

The post All You Need To Know About Google Sheets Chips appeared first on TECHBLOGBOX.

Google does not tell users how long the Google Account has been flagged for deletion. If you want to recover a Google account, you should do it as soon as possible.

Please note that even if you recover your account, you may not be able to recover your Google Account data. However, you can use your account to sign in to Gmail and other Google services that require your Google account to sign in.

How to recover a deleted Google account?

The one and only way to recover your Google account is to go to the Google account recovery page.

Step 1: Go to the Google account recovery page. Enter the login email address or phone number and click Next.

If you get messages like “This account has been deleted and cannot be recovered or Cannot find your Google account or Please try again, ” you can no longer recover this account.

Step 2: You will be asked questions to confirm that this Google account is yours. Answer as many questions as possible. If you don’t know the answers of questions, try inviting one. You must prove ownership of the account.

You may be asked to give a contact email address to submit a verification code. Please ensure that the email address you provide is valid and accessible. You may also be asked additional questions.

Suppose you’ve completed the account recovery steps and still get the “Google couldn’t verify that this account belongs to you” message. In that case, you can repeat the recovery process to see if you can recover the account.

Is it possible to trace a deleted Gmail account and find the IP address of the previously logged-in device on this device?

At the very least, when a Gmail account is deleted, it is publicly deleted. It may leave traces of the address if used for something else. Inside the headers are IP addresses, one of which *might* be a source address. However, an IP address only identifies a device and often for a limited time.

Can the police track a deleted email account?

They cannot track an email account if the mail server is not under their jurisdiction. If that’s the case and they can show a probable cause, they can likely track an active account. An inactive account? One that is no longer on the server because the space it was using was overwritten? Even if they had permission, they probably couldn’t.

How to Recover Deleted Emails in Gmail in 30 Days?

If you delete emails, They stay in your Trash folder for 30 days. If you mark emails as spam, it remains in the spam folder for 30 days. During this period, you can recover deleted emails in Gmail as follows.

Method 1. Recover Deleted Emails via “Mail & Spam & Trash.”

Gmail’s Mail & Spam & Trash option can be beneficial for finding emails in spam. It is better to check your e-mails on a computer rather than via a mobile application because some features are unavailable in the latter.

Step 1. Open Gmail on your computer. In search box, click the down arrow.

Step 2. Select the “All Mail” drop-down menu, then select “Mail & Spam & Trash.”

Step 3. Enter some information from the missing email. For example, “From whom” or “To whom.” (Here, we take Google as an example.) If unsure of the exact words or details, leave the fields blank.

Step 4. Click “Search” at the bottom of the box. Then all your deleted emails will be displayed. You can quickly recover them.

Method 2. Recover Deleted Gmail Emails by Editing/Removing Filter

You may create a filter that automatically archives or deletes certain emails. You can check your filter by doing the following:

Step 1. Open Gmail in a browser. Go to the “Settings” icon at the top right and select “Settings.”

Step 2. Click on the “Filters and Blocked Addresses” tab at the top. Look for filters containing the words “delete” or “skip the inbox.”

Step 3. Click “Edit” or “Delete” on the right. If you choose Edit, click Next to edit the filter.

Step 4. Uncheck Skip Index and Delete, then next Update Filter.

Step 5. If you select “Delete”, select “Delete” > click “OK” to confirm.

Method 3: Recover Deleted Emails from Gmail Trash Folder

Some users may have hidden Gmail trash cans, which will help you unhide them and recover deleted emails in Gmail from the trash.

Step 1. Open your Gmail account and log in > click “Settings” > “Labels” > “Display”. It will bring up your Trash in the left pane of the Gmail window.

Step 2. Now you can see all deleted e-mail files in the Trash folder. Select or highlight the emails and files you want, then click the email icon with the words “Move to” at the top of the window to move your deleted emails to the inbox.

ALSO READ: Choosing The Right Option With Laser Engraving Machines

ALSO READ: 5 Reasons The Entertainment Industry Will Look Different In 2022

The post Can a Deleted Google Account Be Traced? How To Recover It? appeared first on TECHBLOGBOX.

Emails are a great way to stay linked with loved ones, especially when they live across the globe. Perhaps you feel like sending emails is outdated, and you’re not convinced it’s worth it.

Sounds familiar? Luckily, we’re here to change your mind. Here are the ten benefits of email.

Efficient

One of the top benefits of using email is that it’s efficient. You know that once you hit “send,” the email will reach the recipient within minutes or, at the very least, in several hours. It is far more effective than sending a fax or traditional post, which could take days.

Further, your email provider automatically saves this entry, so you needn’t store it in a physical book. And, if you’re a business, you and your team can use an email template, so everyone maintains a corporate tone.

Plus, there’s little chance of human error, so you don’t have to comb through the message to find grammatical issues. And because you copy and paste the news, you’ll save a considerable chunk of time that is better used for other areas of your business.

2. Free to Use

“Should I use email?” You ask.

The beauty of emails is it doesn’t affect your budget because it’s universally accessible. All you want is an internet connection, but apart from that, you can send unlimited emails across the world, irrespective of the size or type of document.

Plus, you can block people you no longer want to contact. You can learn how to do this here: https://setapp.com/how-to/block-emails-on-yahoo.

3. Boosts Sales

You may wonder, “is email outdated?” but you will guarantee that maximum businesses control the power of email marketing to reach their target audience.

Email marketing campaigns let you feature promotions or a recent product launch, so customers can click through and make a purchase. You can also send automated emails to remind prospects that they’ve abandoned their cart or send a follow-up survey to ask for feedback.

4. Easy Referencing

In the email vs. instant messaging debate, know that both are fantastic for saving references so you “have receipts.”

Enter the recipient or subject title into the search bar, and you can retrieve messages easily. It is far easier than sifting through paperwork or information scribbled on sheets of paper.

And because you have an enormous amount of storage, you needn’t worry about deleting essential messages like you would with a phone. So in the email vs. texting debate, email gets the point.

5. User-Friendly

Emails are user-friendly, a massive bonus for technophobes. Send an email, enter a recipient, add a subject, and write a message before hitting send.

It’s also easy to view new messages, as you receive a notification with visible contact details.

6. Accessible 24/7

As long as if you have an internet connection, you can receive and send emails. And nowadays, users can install an email app so you can shoot off messages from your smartphone. It is fantastic if you’re often traveling and need to contact the office or your loved ones.

Also, you can set up an email automation message, so people know you’re on vacation or out of the office for a certain period.

7. Environmentally Friendly

In the U.S, an average person uses between 250 to 300 kilograms of paper every year, whether it’s at work or home. This staggering statistic shows we must reduce this number by going paperless whenever possible.

Enter: emails.

Because you send messages via an electronic service, you save money and trees in the process. It’s a win-win!

8. Can Add Attachments

A fantastic feature of emails is how you can attach a document and send this to multiple people simultaneously. You can add photos, videos, music, and document or PDF files for free.

Check your internet provider to see if there is a limit to the email attachment size, but most accommodate a large file. Or, in the worst-case scenario, send these attachments over several emails, so your recipient receives them in a timely fashion.

9. Increases Leads

Businesses use email marketing to increase leads, as it lets you nurture relationships and improve conversions. It also means you don’t waste time on dead-end prospects as you can track who opens your emails or clicks the link.

Plus, you can drive traffic to your website via email, which will boost SEO. But make sure every message contains a call-to-action (CTA) and adds value to the consumer, so they don’t mark you as junk or spam.

10. Can Send Personalized Content

In your emails to customers, personalize each one by adding the recipient’s name in the subject line. Studies show that doing this increases open rates by 50% and result in a 58% higher click-to-open rate.

You should also segment your contact list so you can send relevant content to the right clients. For example, if you want to reach returning customers, you’d use a different email marketing campaign than with a prospect.

Further, emails let you tailor every message, so it aligns with your brand identity. And you can change images, copy, and the subject line to boost your engagement.

These Are the Main Benefits of Email

Hopefully, you now know the top benefits of email.

It’s a cost-effective, efficient, and user-friendly way to connect with others across the globe. Email is also fantastic if you’re a business and want to stay at the forefront of your customers’ minds. Download your desired provider’s app or email your loved ones via your browser. Happy messaging!

ALSO READ: How to merge cells in Google Sheets

The post You Have Unread Messages! 10 Benefits of Emails That You Should Read About appeared first on TECHBLOGBOX.