MICROSOFT KE MASTER BANO BY A.K.V

Friday, December 31, 2021

Script date time function by coading

Thursday, December 30, 2021

Google sheet ke script date formula

Saturday, December 4, 2021

Blinking sheet by color

function onEdit(e)

{

var ss = SpreadsheetApp.getActiveSpreadsheet();

var mysheet = ss.getSheetByName("Working Sheet Glue dept.");

if( activeCell == "i4" )

var activeCell = ss.getActiveCell().getA1Notation();

{

for(var i=0;i<50;i++)

{

if( i%2 == 0 )

mysheet.getRange("i4").setBackground("GREEN");

else

mysheet.getRange("i4").setBackground("WHITE");

SpreadsheetApp.flush();

Utilities.sleep(500);

}

Details aakash verma

Connection data

https://docs.google.com/spreadsheets/d/1BVxe7WHRyKnJzvosExEGk8U2aCUcxPn9k7Hx4yv23hY/edit?usp=sharing

Master

https://docs.google.com/spreadsheets/d/1lFw6s1xhARnOam0f1G3axnIgv-phIDGKGftpIRuZ5WM/edit?usp=sharing

Stock

https://docs.google.com/spreadsheets/d/1mdhU9uAbmci2KjdMtvYckstVc4gIWu5uDvtjSvG-YMs/edit?usp=sharing

Wednesday, December 1, 2021

ENGLISH LEARN WITH ADVANCE VOCABULARY

Home

▼

Saturday, November 20, 2021

MAIL ID:- brpentpvtltd@gmail.com

Pass. sonu@9999661903

BHARAT PAY

ZOMATO

(NEWS AGE BHARAT PAY)

new_age_bakers

PASSWORD : 8076021725

(BHARAT PAY)

puri_baker_8595627478

8595627478

PURIBAKERS.PVT.LTD

PAS : PURI2015

at November 20, 2021

No comments:

Advance formula of Google sheet

1.=D4+ SUMIFS(Sheet2!$L$3:$L,Sheet2!$J$3:$J,$B$4:$B)+sumifs(RETURN!$E$3:$E,RETURN!$C$3:$C,B4)-sumifs (TRANSFER!$E$3:$E,TRANSFER!$C$3:$C,B4)

2. =ARRAYFORMULA(IFERROR(VLOOKUP(C3:C,Sheet2!$B$4:$C,2,0),""))

3. =ARRAYFORMULA(if(B4:B,"PPF-RL-"&row(B2:B)-1+10000,""))

4. =IF(H4="PE",G4,IF(H4="PP",G4,IF(H4="PE PP",G4,"")))

5. =IF(H4="PE PP",G4,IF(H4="PP",G4,""))

6. =IFERROR(M4*N4/1000," ")

7. =ARRAYFORMULA(IF(O4:O=0,"PENDING","Complete"))

8. =ARRAYFORMULA(IF(P4:P="COMPLETE", HYPERLINK("https://docs.google.com/forms/d/e/1FAIpQLSd8DQvOYP3bWg0pojmdRI1a9lwJCqnspnn8ZW_iA0JVXr-iHQ/viewform?usp=pp_url&entry.2009608542="&A4:A&"&entry.820423580="&J4:J&"&entry.1551706892="&C4:C&"&entry.2022927099="&D4:D&"&entry.1318474386="&L4:L&"","Open"),""))

9. =ArrayFormula(if(C3:C="","",row(C3:C)-1))

10. =iferror(VLOOKUP(C3,'PPF PCS -IMS'!$B$4:$C$2503,2,0),)

11. =iferror(SUM(filter(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1qqfPKw6B2Cxn6veN1Y0oq-4RaXfiYRLjdzotVWeT42A/edit#gid=0","Transfer!$d$214:$d"),IMPORTRANGE("https://docs.google.com/spreadsheets/d/1qqfPKw6B2Cxn6veN1Y0oq-4RaXfiYRLjdzotVWeT42A/edit#gid=0","Transfer!$b$214:$b")=B4)),0)

12. =(D4+E4)-SUMIF('PPF ROLL-PMS'!$E$4:$E$1001,B4,'PPF ROLL-PMS'!$F$4:$F$1001)

13. =iferror(INDEX($X$4:$X$11310,MATCH(I5,$V$4:$V$11310,0)),"")

14. =IF(O1,O1,IF(N1="DONE",NOW(),""))

15. =IF(N1<>"",IF(P1<>"",P1,(NOW()-A1)/24),"")

16. =ARRAYFORMULA(if(B2:B,text(ifna(VLOOKUP(A2:A,{'FORM RESPONSE'!B:B,'FORM RESPONSE'!A:A},2,0),""),"dd-mm-yyyy hh:mm:ss"),""))

17. =ARRAYFORMULA(if(B2:B,IF((M2:M+N2:N)>=L2:L,"Completed","Pending"),""))

18. =ARRAYFORMULA(if(B2:B,if(round(IFna(VLOOKUP(J2:J,Sheet2!$A$2:$E,5,0),"")*H2:H,0),round(IFna(VLOOKUP(J2:J,Sheet2!$A$2:$E,5,0),"")*H2:H,0),"NO DATA"),""))

19. =ARRAYFORMULA(if(B2:B,(G2:G*H2:H)/1000,""))

20. =ARRAYFORMULA(IF(B2:B,ifNA(VLOOKUP($J$2:$J,Sheet2!A1:E,2,0),""),""))

21. =ARRAYFORMULA(IF(O4:O="COMPLETED", HYPERLINK("https://docs.google.com/forms/d/e/1FAIpQLSd8DQvOYP3bWg0pojmdRI1a9lwJCqnspnn8ZW_iA0JVXr-iHQ/viewform?usp=pp_url&entry.2009608542="&A2:A&"&entry.820423580="&J2:J&"&entry.1551706892="&C2:C&"&entry.2022927099="&D2:D&"&entry.1318474386="&L2:L&"","Open"),""))

Saturday, November 27, 2021

Send mail automatic actuall

// This constant is written in column C for rows for which an email

// has been sent successfully.

var EMAIL_SENT = 'EMAIL_SENT';

/**

* Sends non-duplicate emails with data from the current spreadsheet.

function sendEmails2() {

var sheet = SpreadsheetApp.getActiveSheet();

var startRow = 2; // First row of data to process

var numRows = 20; // Number of rows to process

// Fetch the range of cells A2:B3

var dataRange = sheet.getRange(startRow, 1, numRows, 3);

// Fetch values for each row in the Range.

var data = dataRange.getValues();

for (var i = 0; i < data.length; ++i) {

var row = data[i];

var emailAddress = row[0]; // First column

var message = row[1]; // Second column

var emailSent = row[2]; // Third column

if (emailSent !== EMAIL_SENT) { // Prevents sending duplicates

var subject = 'Sending emails from a Spreadsheet';

MailApp.sendEmail(emailAddress, subject, message);

sheet.getRange(startRow + i, 3).setValue(EMAIL_SENT);

// Make sure the cell is updated right away in case the script is interrupted

SpreadsheetApp.flush();

}

Friday, November 26, 2021

Skm inustries joining time

null

22/11/21 se company join kya h mene aur sare documents 10 ka certificate and 12 th ka certificate and computer diploma aur adhar card provision sab jama karwa dya