google sheets – Can automatic send emails when checkbox = True?

I’m looking for an script can automatic send emails when checkbox is True.
This is my format example:
enter image description here

What i want is when im clicking on checkbox = True at F2, i can recieve an email with excactly contents from A2 to E2, looks like this:

The emails address can be set on the scripts too.
So please help to this. I lost my hair to try someway, but its hard to me.
This is the sample spreadsheet of my project:

my samle spreadsheet project

Getting div/0 error Google Sheets

I have a Google Sheets which basically looks like this:

Enter a number: cell1here

Enter another number: cell2here

Cell2 number converted to correct units: cell3here (cell2 * cell 8)

total: cell4here (cell2 divided by cell1)

So basically the user just needs to enter a number in cell1 and cell2, and other numbers will show up in cell3 and cell 4.

But when I keep cell1 and cell2 blank, I get an error in cell4, saying #DIV/0. But, when cell1 and cell2 are blank I just want cell4 to show 0.00 instead. Is this possible, if so how can I do this?

formulas – Convert columns of ISO 8601 strings to dates in Google Sheets

I’m pulling data to my sheet from an API using an ImportJSON function. The data array contains mixed data, including several columns of ISO 8601 date strings in UTC. For example:

2020-06-02T00:00:00Z
2020-06-02T03:00:00Z
2020-06-02T14:30:00Z

Google Sheets doesn’t apparently recognize these as dates, or at least applying a date format to these columns doesn’t do anything. Can I wrap a formula around the ImportJSON function that would parse certain columns to format the date and time properly?

A truncated example of what the data array might look like:

id | data1 |  time1                 | data2  | time2
_____________________________________________________________________
23 | "abc" | "2020-06-02T00:00:00Z" | "def"  | "2020-06-02T02:00:00Z"
24 | "efg" | "2020-06-02T03:00:00Z" | "ijk"  | "2020-06-02T05:00:00Z"
25 | "lmn" | "2020-06-02T14:30:00Z" | "opq"  | "2020-06-02T16:30:00Z"

I probably could query each time column separately. This means I should write several formulas, for example

=QUERY(data; "select A, B")

for each consecutive column group without formattable data, and

=ARRAYFORMULA(IFERROR(DATEVALUE(LEFT(QUERY(data; "select C"); 10)) + TIMEVALUE("klo " & MID(SUBSTITUTE(QUERY(data; "select C"); ":"; "."); 12; 8)); ""))

for each formattable date column and so on. But this gets very complicated and is tedious to change later, and I was wondering if this could be done in a single formula. I could not find any advice to transform multiple columns with mixed datatypes.

How to delete a google sheets row without affecting formula references

My question if you can help is about google sheets getting values from a google forms.
i’m using the query function to get the populated rows once you submit your answer, the problem is that if I delete a row, the the reference used in the formula changes, actually it increment by 1 what gives a black cell, and if i decrease the refertence I get the data. can we delete a row without affecting the references?

here the form link: https://forms.gle/BCxXf2dpgHK4dmQg6

here the spreadsheet:https://docs.google.com/spreadsheets/d/1T7BV_p5K-k4JWBjcMd1FkYqO1Bh7TWpRdlUfPUrpyAA/edit?usp=sharing

if you use the form, the spreadsheets is populated and the result is in the result sheet, but if i delete all data in FormResponce1, and fill the form again, it works fine with the FormResponces but the result sheet is empty
Thank you,

google sheets – How to change cell format on ImportHTML Function

I’ve used the ImportHTML function to scrape play-by-play information from Basketball Reference.

I am using a Vlookup to create a rating system based on time, point different, and several other factors.

I realized the TIME vlookup isn’t reading correctly, but the formula is exactly how it should be (I’ve tested it, and it works fine when I type in the info manually). It only doesn’t work on the time that is coming from my ImportHTML.

I can’t get the format to match – I’ve tried every format option on both my vlookup & the data, and tried forcing it with the TEXT function (might of not done that correctly).

I’m at an absolute stand-still at this point — has anyone experienced anything similar?

Other ways to force a format change on imported data? or another way to correctly pull the values from a range of times? I’ve tried the Lookup function as well.

For Reference:

=VLOOKUP(H11,$J$2:$L$6,3,TRUE)

upper lower bounds

importfunction

google sheets – How to create a formula to look at my most recent past 20 scores in a column and averages the lowest 8 scores

In Google Sheets I would like to create a formula to look at my most recent past 20 scores in a column and averages the lowest 8 scores.

In another post I found the following formula that will average my 8 most recent scores. However, I need it to look at my most recent 20 scores and average the lowest 8.

Here was the formula I found:

=AVERAGE(QUERY(SORT(K3:K, ROW(K3:K)*ISNUMBER(K3:K),0),"select * LIMIT 8"))

Google Sheets value on chart off from source by very small fraction

Trying to figure out why Google Sheets chart is off from the source data by a small fraction. My sheet has 7 rows of data and a sum row. All data only has 2 decimal points and the sum obviously has 2 decimal points. Yet when plotted, the sum is off as shown in the screenshot below.

Screenshot

The callout on the chart is pulling its data from cell C12. Formula for C12 is just SUM(C4:C10). I expanded the decimal places in C12 to show that nothing was hidden/rounded/truncated. Trying to understand why this is happening and how to stop it.

How to enqueue multiple style sheets into my child theme in wordpress (oceanwp)

I would like to import several styles sheets in my child theme (oceanWP).
I succeed to do it with “@import” method but not with enqueueing scripts and styles.

My child theme uses this “style.css” :

/*
 Theme Name:   oceanwp-child
 Theme URI:    https://monsite.com
 Description:  OceanWP WordPress theme example child theme.
 Author:       Phil
 Author URI:   https://voyageinitiartique.com
 Template:     oceanwp
 Version:      1.0.0
*/
/*@import url("./custom/navbar.css"); First, I try to import this with enqueueing method */
@import url("./custom/home.css");
@import url("./custom/voyages.css");
@import url("./custom/concept.css");
@import url("./custom/carnets.css");
@import url("./custom/contact.css");
@import url("./custom/articles.css");`

Child theme function.php :

function oceanwp_child_enqueue_parent_style() {
    // Dynamically get version number of the parent stylesheet (lets browsers re-cache your stylesheet when you update your theme)
    $theme   = wp_get_theme( 'OceanWP' );
    $version = $theme->get( 'Version' );
 // Load the stylesheet
       wp_enqueue_style( 'child-style', get_stylesheet_directory_uri() . '/style.css', array ('oceanwp-style'), $version );
       wp_enqueue_style( 'child-navbar-style', get_stylesheet_directory_uri() . './custom/navbar.css', array( 'oceanwp-style' ), $version );
}
add_action( 'wp_enqueue_scripts', 'oceanwp_child_enqueue_parent_style' );

Other syntax tried without success:

wp_enqueue_style( 'child-navbar-style', get_stylesheet_directory_uri() . './custom/navbar.css', array(), '1.0', 'all' );

Is someone can help me ?
Thx !

google sheets – Find the last instance of multiple values

I really need some help with this.

I need to search for the value of A2:B2 account1(A2):site1(B2) in another tab in google sheets and it needs to return the row number of last occurrence/entry of the values in A2:B2 in Column C2.

Tried multiple formulas and I couldn’t seem to make it work.

Recommendations and advice will be truly appreciated. And thank you in advance as well.

google sheets – Using a query and tick boxes to auto fill another tab

Please use the following query formula:

=QUERY('R&MCollections'!J1:Q," SELECT * WHERE P = TRUE ")

(you can change ranges to your needs)

IMPORTANT
Normally, when referring to text, the WHERE clause should be wrapped with single quotes ' '
But, when the clause depends on a Tick box, we MUST NOT use the single quotes.

As an example:
If one would look for John the WHERE clause should be WHERE P = 'John'

Functions used: