google sheets – IF function that leaves the last number calculated if statement is true/false

I am trying to write a formula that updates a number in the cell if another cell is empty, and leaves the last number calculated if the other cell is not empty. I am calculating my profit, which changes until I actually collect it. So far I have this:
=IF(ISBLANK(K2),C2-H2,())
Obviously it is not possible to do this. Prove me wrong

plugins – Connect to Google reviews and ratings data and put into schema.org structured data in website source code?

I have found Google reviews plugins, but these all seem to be meant to embed Google reviews on the front end of web page.

Instead I am wanting to pull in live/synced reviews data and include it in schema.org structured data “dynamically” – eg # of reviews, avg star rating.

Thanks much!

How to add filter in Gmail to label any email which is from/to an email address from one of your Google Contact labels?

I want to make my clients’ emails stand out more than just “important” allows, and also group them better. I have added all client emails to a Google Contacts “Label” and want to make all emails to/from these client email addresses to be labelled in Gmail.

There is a manual solution here: How to add filter and label to group in Gmail contacts?

But it doesn’t account for new emails you add to the contact label in future, and required manual updating.

Any help on my specific question, or an alternative solution would be much appreciated.

Selling – GDPLYR PRO – Google Drive Proxy Player | NewProxyLists

This is the pro version of GDPLYR which is developed by codyseller.
This Pro version have many features which you all desire. In this version you can manage all of your google drives account, Within 2 clicks you can switch between drives, you turn on/off sharing of script within script..
Copy files from google drive to another google drive without wasting your precious bandwidth.
HLS Video system, with this you can prevent visitors from downloading your precious video (Protection from IDM and other video downloading sites)

SUPPORTED SOURCES:

  1. Google drive
  2. Google photos
  3. Onedrive
  4. Ok.ru
  5. Yandex
  6. Direct (also support HLS links – m3u8)

DEMO-
GDPLYR PRO
site- pro.gdplyr.com/login
username : admin
Password : 1234

Main Features-

% Unlimited playbacks
% Hot link protection
% Private video stream
% Direct stream links (mp4)
% Load balancer
% IDM protectd HLS video system
% JW and plyr.io players
% Unlimited alternative links
% Google drive backup (auto/manual )
% Player advertisement (Vast/popads)
% Player subtitles
% Intergrated with your gdrive account
% Drive to Drive copier
% Remote file uploader to gdrive
% Bulk import
% Multiple google drive accounts supported
% Clean admin UI
% One click installation

About HLS video system-
GDplyr Pro script will convert your google drive file to HLS format and then save it in your local server storage.
Script will save each hls segment as image (png) file and this will prevent you from getting DMCA copyright notice.
Not only that this hls system will save lot of your server bandwidth and also this HLS system prevent IDM and Other sites from downloading your video
(you can select different server for local storage)
.

About D2D Backup System-
After you added new gogole drive file, GDplyr Pro will automatically create backup of files to your backup drives. Well you can also do it manually by yourself.

REQUIREMENTS-
$ php7.x
$ mysqli/ curl
$ FFmpeg (If you use hls system)
$ Apache / Nginx (Apache recommended)
$ Shared host / VPS

Product listing – rdigi.store/item/gdplyr-pro-google-drive-proxy-player

Admin if i made any mistake do let me know.
Thank you

 

Google Facing New Antitrust Complaint From Daily Mail?s Owner

Google is facing another antitrust complaint, alleging that Google punishes publishers in search rankings if they don?t sell enough advertising space through Google?s marketplace.

Google Sheets: VLOOKUP formula for a multi line cells range

I have here a sample project, where columns A to C are in FORM RESPONSES TAB/SHEET and columns D and E are in RECORDS TAB/SHEET.

In the RECORDS I have a list of names, in alphabetical order, and a column for BATCHES(E9).

What I wish to have as an output is to AUTOMATICALLY bring/distribute the batches from RESPONSES!B4:B to the respective attendees in RECORD TAB (E10:E).

NOTE: The names are already available in the Google Form(Checkbox type), so the list of names in RECORD TAB are just the same as in the Google Form.

But the problem is, there are responses in C4:C that has multiple names in a single cell, and I don’t know what to do anymore. hehe. I have already tried the INDEX and MATCH formulas based on how I understood it as a total beginner in Google Sheet, but it only works on the first name.

I hope that someone could help me achieve the output that I wanted to achieve.

Thank you so much and may God bless everyone! 🙂

Here’s the screenshot of my sample project:

Here's the screenshot of my sample project:

googlebot – Mobile usability issues reported by Google at Search Console

Google search console reported that some pages have a Mobile Usability issues:

  • Clickable elements too close together
  • Content wider than screen
  • Text too small to read

Some details:

  • this is not about restrictions in robots.txt
  • some failed pages have less than 8 resources with 550KB size total
  • the failed pages make up a small part of the total and are random
  • “LIVE TEST” for the same URL may fail randomly
  • there is no network problems (packet loss/response time/DNS) with the server where site deployed
  • this issue appeared since April 14th
  • most of the failed pages have 90-99% mobile performance in PageSpeed Insights or Lighthouse

Lighthouse embedded in the Chrome and PageSpeed Insights haven’t found a problem in mobile mode in the same pages that have an issues in Google search console.

But when I use “LIVE TEST” for failed URLs in Google search console, sometimes I get a same failed result with Mobile Usability issues, where CSS file not loaded with a reason “Other error”. I think this is an issues reason but I don’t understand what can I do to fix it, especially if it is due to some netiquette limitation (crawl budget)

google sheets – getting the latest date of something happening (with conditions)

So basically, Ive got two sheets. One (sheet_1) with every single record in the system (over 11000 rows) and the other one (sheet_2) is querying information from that sheet. The relevant information to know is that sheet_1 has 3 columns of interest to me; name of person, thing he/she did and the date he did it. Now in sheet_2, im attempting to create a sort of report about that person, showing all information from sheet_1 that is relevant to that person.

Ive made sort of a statistics section in sheet_2 which shows the incident type, number of times its happened and when was the last time it did happen. What i cant figure out is how to do the “when was the last time it did happen” column.

My first thought was an if function but that didnt work since there was no logic there, so ill give you a more clear explanation of what should happen in the cell:

Cell is supposed to first check the type of incident and the name of the person (both in sheet_2) then cross reference that with sheet_1 and get the “maximum or latest date” for that type of incident for that specific person.

google cloud platform – Create alerts of for two projects in gcp monitoring workspace

Hi I have two projects project-A and project-B. I have created a monitoring workspace in project-A and added project-B in that workspace. I want to create alerts from log based metrics . I have created the log based metrics in project-A and created an alert from it but it wouldn’t trigger for project-B it works for project-A only. For log based metrics my query is –

                  "resource.type="build"
                   severity=ERROR" 

so alert triggers when cloudbuild fails in project-A but not when it fails in project-B. Is it possible to do that?

google – SEO Safe way to permanently delete thousands of outdated pages

Our site is a huge one with about half a million pages built over the years. Many pages rank well for competitive keywords and have attracted high-quality link equity over the years. However, looking now, we have come to a conclusion that about 25% or about 100,000 pages are outdated and don’t bring us any value in terms of revenue. Instead, they cost us server resources to maintain. We are planning to remove these pages PERMANENTLY. What could be the safe way to remove them without negatively affecting the SEO of the REMAINING pages?


PS: Kindly help me with appropriate status code and duration (all at once or gradually)..