8. Google Sheet - How to Add Row No / Line Number Automatically Using Formula in Hindi | Row Formula

[@nitishparmar3698]

Well done

[@shanesharma3195]

Cool... The way you combine more than one function together is great thing.

[@rahulthementor4846]

Glad to hear

[@GovindSharma-ip4iv]

Earlier I was looking the same thing and found this. Nice video👍

[@rahulthementor4846]

Cool, thanks

[@mustakeemmustakeem6282]

Good 👍

[@rahulthementor4846]

Thanks

[@erl412]

Hi, I'm trying to make invoice# every Monday. How does it changes automatically every time I open Google sheet. For example, invoice #001 and then the week after invoice #002. Thanks

[@rahulthementor4846]

It is possible but with App script. I have not started App script yet as my formula Series ongoing but for you I have created a Small script which will help you. function autoIncrement() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var ws = ss.getSheetByName("App"); var cellvalue = ws.getRange("A1").getValue(); cellvalue=cellvalue+1; ws.getRange("A1").setValue(cellvalue); } Copy and paste above code in app script editor and Create Trigger onOpen to run this script automatically when you open sheet next time. Change name of your sheet to App or change name in code. Secondly change Invoice number reside in which cell if it is in A1 that fine otherwise change A1 to desire cell name wherever you invoice number exist.

[@umasharma6615]

Excellent stuff

[@rahulthementor4846]

Thank you! Cheers!

[@rahulthementor4846]

@1CALLFix Solutions: you may use ArrayFormula(ROW(B2:B)+2107999) formula to generate numbers like 2108001, 2108002, 2108003, 2108004. Let me know in case of any other query. thanks

[@FORYOU-wb1rx]

good job

[@upendralokhande4297]

Please provide Formula In Description Always when you make video

[@rahulthementor4846]

Sure. Thanks for watching

[@Jatin-nt3cs]

Gjjb