Copiar formula en columnas cada que se ingrese una fila en hoja de Excel

[Roberto Carlos Melgar]

Buenas tardes a todos. me podrían ayudar por favor.

he creado un pequeño formulario con algunos campos tres de sus campos son 

Fecha formato dd/mm/aa 

Hora H:mm:00 

ahora en otra columna estoy uniendo la fecha y la hora con campo fecha + campo hora, pero cuando ingreso una nueva fila me gustaria que detecte que se ingreso una fila y que esas formulas se llenen automaticamente sin tener que ir a copiar y pegar la formula, como hago eso con gs google script 

por favor y les agradezco por la ayuda.

Rm

[Darren D'Mello]

Could you share the file with us?

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/4c894cab-1f0f-4f2d-9f01-d87ebb526c2ao%40googlegroups.com.

--

Best,

Darren

[Emerson Maia]

Boa tarde , segue um exemplo. 

function somaDatas(){

var ss = SpreedsheetApp.getActive()

var sheet1 = ss.getsheetByNamer("Sheet1")

var lestRow = sheet1.getLastRow()

var data = sheet1.getRange(2,1,lastRow - 1,3).getValues();

Logger.log(data)

var totalArray = []

data.forEach(function(row) {

var data1 = row[0]

var data2 = row[1]

var total = data1 + data

row.push(total)

totalArray.push([total])

Logger.log(row)

});

Logger.log(totalArra)

sheet1.getRange(2,4,lastRow -1, 1).setValues(totalArray)

}

--

You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/4c894cab-1f0f-4f2d-9f01-d87ebb526c2ao%40googlegroups.com.

--

Emerson Maia 

+5562 991911266 Whatsapp

[Jean-Luc Vanhulst]

You can use:   

 sheet.getRange(2,4,lastrow-1,1).setFormulasR1C1( "=R[0]C[-2]+R[0]C[-1]" );

Jean-Luc Vanhulst - President - Write2market.com
Cell: 347-453-7686

ᐧ

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAA2OWiA2-sg7Ck1f2vzpvGOLDBXL-6YHc4905iaYvn-v0aKkWA%40mail.gmail.com.

[Roberto Carlos Melgar]

Muchas gracias por la ayuda

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAA2OWiA2-sg7Ck1f2vzpvGOLDBXL-6YHc4905iaYvn-v0aKkWA%40mail.gmail.com.

[Roberto Carlos Melgar]

Muchas gracias, por la ayuda

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAKTLZ53ok9r8TDeQPmEYNtCQFtdDPBk_oCqzxwx%3D68qFk7ywrQ%40mail.gmail.com.