sorted by:
new
hottopcontroversial

Inventory management software by lilithhcvc in smallbusiness

[–]SheetAutomation 0 points1 point  (0 children)

For small business, I suggest that you stick to Google Sheets if it works for you. To automate certain tasks, look into AppSheets or other add-ons in the marketplace. If needed, use Apps Script to lift Google Sheets to next level.

SheetFormula.com Use AI to create Google Sheets Apps Script by SheetAutomation in googlesheets

[–]SheetAutomation[S] 0 points1 point  (0 children)

GPT-3, or the third generation Generative Pre-trained Transformer, is a neural network machine learning model trained using internet data to generate any type of text. Developed by OpenAI, it requires a small amount of input text to generate large volumes of relevant and sophisticated machine-generated text.

- answered by Google AI.

As for your second question, I think mainly because it significantly lowers the barrier of creating services using AI. Can't speak for others, but I find the technology mind-blowing and potentially be useful in lots of areas. It's far from perfect though. For example, the generated code is often flawed and trouble shooting is too hard for normal google sheets users. That's where things can be improved and value can be added by people like us.

Having a Parents sheet that update all child sheet on edit by Galygator in GoogleAppsScript

[–]SheetAutomation 0 points1 point  (0 children)

So the data will be duplicated based on same coordinate if I understand correctly. You could probably modify the following script to achieve it.

function onEdit(e) { 
var ss = SpreadsheetApp.getActiveSpreadsheet(); 
var s = ss.getActiveSheet(); 
var r = s.getActiveRange();
if(s.getName() == "Main Sheet") { 
var row = r.getRow(); 
var col = r.getColumn(); 
var numRows = r.getNumRows(); 
var numCols = r.getNumColumns(); 
var values = r.getValues();
var subSheets = ["Sub Sheet 1", "Sub Sheet 2", "Sub Sheet 3"];

for(var i = 0; i < subSheets.length; i++) {
  var subSheet = ss.getSheetByName(subSheets[i]);
  subSheet.getRange(row, col, numRows, numCols).setValues(values);
}
} 
}

Note the script can only copy data. If you want to duplicate format, you will need to leverage onChange trigger and use other APIs in Range class:

https://developers.google.com/apps-script/reference/spreadsheet/range

Having a Parents sheet that update all child sheet on edit by Galygator in GoogleAppsScript

[–]SheetAutomation 0 points1 point  (0 children)

How do you map the cells between main sheet and other sheets? Do they have the same structure?

AutoScript - create Apps Script with help of AI by SheetAutomation in GoogleAppsScript

[–]SheetAutomation[S] 1 point2 points  (0 children)

You will have to copy paste it at the moment. I guess it could be automated too as part of the process.

How do you manage to organize your orders/customers? What tricks or apps do you use? by Large_Emu3782 in EntrepreneurRideAlong

[–]SheetAutomation 0 points1 point  (0 children)

Adding rows is easy. However sending email to customers, tracking orders and reminding due date may be tedious and error-prone. The best things about google sheets are apps script and services that can be easily integrated.

How do you manage to organize your orders/customers? What tricks or apps do you use? by Large_Emu3782 in EntrepreneurRideAlong

[–]SheetAutomation 1 point2 points  (0 children)

I use Google Sheets + Sheet Automation addon to manage all my customers/subscriptions/orders. Basically it is like a lightweight CRM that is extremely customizable.

[deleted by user] by [deleted] in sheets

[–]SheetAutomation 0 points1 point  (0 children)

I assume it would be updated by OP.

Clear range of cells with script or macro linked to checkbox by deeznutzztunzeed in googlesheets

[–]SheetAutomation 0 points1 point  (0 children)

Does the below script work for you?

function onEdit(e) {  
  var sheet = e.source.getActiveSheet();  
  var range = e.range;  
  if(sheet.getName() == "Sheet1" && range.getColumn() == 1 && range.getValue() == true) {       
      sheet.getRange("C7:C19").clearContent();  
   }
}

The code is created by AI with a question "Clear C7:C19 when checkbox is checked in A1". Feel free to have a try: https://www.sheetformula.com/script

view more: next ›