Tag Info

New answers tagged

2

The following little script limits the cell input to 5 positions and adds the surplus as a note to the cell. Code function onEdit(e) { if(e.value.length > 5) { var c = e.source.getActiveCell(), v = e.value; c.setValue(v.substring(0,5) + "..."); c.setNote("Remaining text was: \n....." + v.substring(5)); } } Explained On each and every ...


2

Use a Data Validation with a custom formula. If the cell to limit the value length is A1 and the length limit is 5, then the custom formula is =LEN(A1)<=5 References Data Validation - Docs Editors Help


0

I wasn't quite sure what you meant by Range as an input to your custom function. Is this the source range or destination range? Anyways, this is something that should hopefully get you started. There is no timer element, nor is it a custom function. But can be converted to one easily. The manual timer element can be achieved by adding a trigger. In script ...


0

Convert your csv data into tsv (tab separated values). Paste it then.


2

Maybe give this a try: function onOpen() { SpreadsheetApp.getUi().createMenu('Custom Menu') .addItem('Make Negative', 'makeNegative') .addToUi(); } function makeNegative() { var res = [], range = SpreadsheetApp.getActiveSheet().getRange('D2:E'), val = range.getValues() .forEach(function (r, i) { r[0] = r[1] === 'debit' ...


1

You can add the alias in the advancedArgs as shown here: var alias = "email@example.com"; GmailApp.sendEmail(person[1], emailSubject, emailMsg, {from: alias});



Top 50 recent answers are included