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

In this video, we have covered Row formula with Array formula to get line number / Row number automatically. Whenever you need to generate row number in your data set automatically you may use this formula.
Google Sheet Videos Playlist URL - • Google Sheet Tutorials...

[@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

[@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

[@umasharma6615]

Excellent stuff

[@rahulthementor4846]

Thank you! Cheers!

[@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.

[@Jatin-nt3cs]

Gjjb

[@upendralokhande4297]

Please provide Formula In Description Always when you make video

[@rahulthementor4846]

Sure. Thanks for watching