comunidad.gedu.es
#3# características no documentadas de las hojas de cálculo de Google
4 min · · Encontrarte con algo que no sabías que estaba ahí siempre resulta gratificante. Es como dar con un tesoro ✨ en tu jardín cuando pensabas que en él no había nada más que hierbas, gnomos y otr... · Shared by 2, including Pablo Felip
twitter.com
¿Google Sheets o SQL?
· We've detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using twitter.com. You can see a list of supported browsers in our… · Shared by 3, including Pablo Felip
twitter.com
Toggle drawings used as buttons in Google Sheets
· We've detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using twitter.com. You can see a list of supported browsers in our… · Shared by 2, including Pablo Felip
twitter.com
Una plantilla de hdc que hace scraping del SEPE
· We've detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using twitter.com. You can see a list of supported browsers in our… · Shared by 2, including Pablo Felip
twitter.com
#GoogleSheets #AppsScript custom functions and the global scope
· We've detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using twitter.com. You can see a list of supported browsers in our… · Shared by 2, including Pablo Felip
twitter.com
Cómo identificar filas con valores duplicados
· “#gsheetconsejo del día:
Cómo identificar 🧐 filas con valores duplicados👯 (usando una o más columnas como clave) en #GoogleSheets mediante:
1⃣ https://t.co/Rf7eBCY6jb / https://t.co/Rf7eBCY6jb.CONJUNTO
2⃣ ARRAYFORMULA
3⃣ FILTER
🖱️ https://t.co/ItolrIVAQo” · Shared by 2, including Pablo Felip
twitter.com
Documentar las fórmulas ofuscadas con notas
· We've detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using twitter.com. You can see a list of supported browsers in our… · Shared by 2, including Pablo Felip
twitter.com
Una función GAS personalizada para generar una lista de eventos a partir de un horario en formato tabla (wip)
· We've detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using twitter.com. You can see a list of supported browsers in our… · Shared by 2, including Pablo Felip
twitter.com
Visibilizando el contenido de celdas ocultas en HdC de Google
· We've detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using twitter.com. You can see a list of supported browsers in our… · Shared by 2, including Pablo Felip
twitter.com
Una plantilla para el cálculo de calificaciones
· We've detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using twitter.com. You can see a list of supported browsers in our… · Shared by 2, including Pablo Felip
comunidad.gedu.es
Ofuscando nombre y apellidos usando las hojas de cálculo de Google
5 min · · Hoy me he encontrado con la necesidad de publicar un listado que incluía nombres y apellidos, asociados a otra información, de un grupo de personas en una de las plataformas de gestión inter... · Shared by 4, including Pablo Felip
twitter.com
Google Sheets y Pandas
· We've detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using twitter.com. You can see a list of supported browsers in our… · Shared by 2, including Pablo Felip
twitter.com
Celdas vacías, cadenas vacías, valores numéricos y valores booleanos
· “Celdas vacías, cadenas vacías, valores numéricos y valores booleanos... Ojito 🧐 con esta tabla, las cosas en #GoogleSheets no son siempre lo que parecen. El 👿 está en los detalles.” · Shared by 4, including Pablo Felip
twitter.com
¿Gráficos en secciones inmovilizadas?
· We've detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using twitter.com. You can see a list of supported browsers in our… · Shared by 2, including Pablo Felip
twitter.com
Barras de progreso GAS usando SPARKLINE()
· We've detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using twitter.com. You can see a list of supported browsers in our… · Shared by 2, including Pablo Felip
twitter.com
Desacoplar (y acoplar) respuestas con valores múltiples: 2 funciones personalizadas GAS
· We've detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using twitter.com. You can see a list of supported browsers in our… · Shared by 2, including Pablo Felip
twitter.com
Usando el operador de propagación JS (...) para crear funciones personalizadas GAS con un nº indeterminado de parámetros
· We've detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using twitter.com. You can see a list of supported browsers in our… · Shared by 2, including Pablo Felip
twitter.com
Una función personalizada GAS para calcular medias móviles
· We've detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using twitter.com. You can see a list of supported browsers in our… · Shared by 2, including Pablo Felip
twitter.com
Usando ARRAYFORMULA() + SEQUENCE()
· We've detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using twitter.com. You can see a list of supported browsers in our… · Shared by 2, including Pablo Felip
twitter.com
Funciones personalizadas con GAS
· We've detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using twitter.com. You can see a list of supported browsers in our… · Shared by 2, including Pablo Felip
twitter.com
Extrayendo y analizando datos con Google Apps Script, hojas de cálculo y Data Studio (webinar 📺)
· We've detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using twitter.com. You can see a list of supported browsers in our… · Shared by 3, including Pablo Felip
twitter.com
Range.setFormula() y la sintaxis de funciones en 🇪🇸
· We've detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using twitter.com. You can see a list of supported browsers in our… · Shared by 2, including Pablo Felip
twitter.com
Convirtiendo sello de tiempo Zulú a #GoogleSheets
· We've detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using twitter.com. You can see a list of supported browsers in our… · Shared by 2, including Pablo Felip
twitter.com
Un tracker #COVID19 en España implementado con #GoogleSheets #AppsScript #DataStudio
· We've detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using twitter.com. You can see a list of supported browsers in our… · Shared by 4, including Pablo Felip
twitter.com
GIFs animados en #GoogleSheets
· We've detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using twitter.com. You can see a list of supported browsers in our… · Shared by 2, including Pablo Felip
twitter.com
Funciones personalizadas GAS para realizar consultas DNS
· We've detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using twitter.com. You can see a list of supported browsers in our… · Shared by 2, including Pablo Felip
twitter.com
Función personalizadas GAS ESPROTEGIDA()
· We've detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using twitter.com. You can see a list of supported browsers in our… · Shared by 2, including Pablo Felip
twitter.com
Usando throw() en funciones personalizadas GAS
· We've detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using twitter.com. You can see a list of supported browsers in our… · Shared by 2, including Pablo Felip
twitter.com
Nueva versión de mi complemento para hojas de cálculo #HdC+
· We've detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using twitter.com. You can see a list of supported browsers in our… · Shared by 2, including Pablo Felip
twitter.com
Error en la implementación de controles de filtro en #GoogleSheets
· “Error en la implementación de controles de filtro en #GoogleSheets 👇
Usuario con acceso en solo lectura recibe mensaje de error cuando intenta usar control de filtro que opera sobre rango afectado por una regla de protección (que solo debería afectar a editores).
¿Alguien más? https://t.co/cArGijXV1h” · Shared by 2, including Pablo Felip
twitter.com
Pablo Felip on Twitter
· “"En las reglas de formato condicional de #GoogleSheets no es posible utilizar referencias a celdas de otras pestañas de la hoja de cálculo"
❌ INCORRECTO ❌
(solo no de manera directa)
Dentro vídeo... https://t.co/l8hPgY9Jbc” · Shared by 3, including Pablo Felip
twitter.com
Concatenando elementos
· “Dice la ayuda de #GoogleSheets que la función CONCATENAR():
👉"Ofrece la concatenación de dos valores. Equivale al operador `&`."
...pero esto (lo de equivale) no es del todo cierto ❌ . Apreciemos mediante una captura la diferencia entre:
💠 &
💠 CONCATENAR()
💠 CONCAT()” · Shared by 3, including Pablo Felip
twitter.com
Repetir el contenido de una celda en varias filas o columnas adyacentes
3 min · · “1⃣🔹4⃣ En ocasiones resulta útil repetir el contenido de una celda de #GoogleSheets en varias filas o columnas adyacentes o entubarlo en otras funciones. Esto se puede conseguir usando de manera… · Shared by 5, including Pablo Felip
twitter.com
Importador++, un GAS que facilita el intercambio y consolidación de datos entre HdC de #GoogleSheets:
· “Señoras y señores, con todos ustedes...
🔄Importador++🔄
Un sencillo #AppsScript que facilita el intercambio y consolidación de datos entre HdC de #GoogleSheets:
📌 Bidireccional
📌 Formato completo
📌 Fórmulas
📌 Tamaño de filas/columnas
📌 Notas
https://t.co/e0siJgXpYm” · Shared by 4, including Pablo Felip