Відео

Aapko sum se pehle IF condition lagani hai

Protect all sheets and give permission to edit only. Only person with the name should be given access to particular sheet. Aap sheet protect karo or jis person ke name ki sheet hai usko hi edit ki permission do. Better ye hai aap sabko alag workbook de usse ek master create kar le so that manager can see.

Ok

Thanks for watching. will be happy agar aap koi example ye koi image ka link de do kaise chaiye aapko. will do that

Control down arrow Karo..

Show me data. Share link of data in comment.

Glad you like it

Thanks for watching. Pls share my channel and keep watching

Will do it further but pls check my all videos. It will also help you in creating fms

Possible

I can do for you. Pls share exact sheet. I also build customise project on google sheet. Pls share file rahulsharma.kumar49@gmail.com

You may send your requirement and i can build project as per your requirement in low cost

You may refer below url for keyboard shortcuts in google sheet ua-cam.com/video/eIgfDyHT9o8/v-deo.html

Thanks for your comment. As of now you have to manage from watching video. Actually because of security reason I have lost my file from email id

Thanks for liking. I will create new one for you. For filter you may use ALT +D+F

@@rahulthementor4846 you have not shared yet ?

@@syedarshad6985 pls manage by watching my video as of now. I am busy with other things now a days.

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.

Thanks for watching

Thanks

Thanks

What kind of data you have? If you have some limited columns then you may use google form and share the link with collaborator for data entry purpose and you will find all entries with correct timestamp. Secondly, pls do not share master sheet just import the data from master with limited time frame. Let me know if it fine for you.

@@rahulthementor4846 I am not prefer google form

@@vernavong There are multiple way to do this task but you are not willing to work in google form. I am giving you small idea hope you were asking the same thing. please copy and paste code in script editor of sheet which you want to lock. function prtect() { var sheet = SpreadsheetApp.getActive().getSheetByName("Sheet22"); sheet.protect(); } Instead of Sheet22 you will have to put the sheet name there or you may rename your sheet to Sheet22. After that you will have to set up time trigger on the basis of your requirement. However i have not start app script but for your requirement small code for you.

@@rahulthementor4846 I tried what you suggested, by copying this code and paste to the script editor with changing sheet to "sheet22". After that add trigger , select event source = Time-driven , select type of time base on trigger and select minute ! but when i share to my collaborator after he add for few minutes lather he can edit again ! It doesn't work

@@vernavong I personally tested and tried before sharing to you. Right click on tab and checked is there protection added or not. Secondly, before sharing this sheet to collaborator you must set up all configuration. You might have already given edit permission to collaborator. If you still feel issue share file with me.

Sure. Thanks for watching

Thanks for watching. Keep supporting and keep sharing.

do you have any tutorial videos for array constrain and array formula and sumproduct?

@@nichcolon1735 ua-cam.com/video/MWz8nHSzogQ/v-deo.html Sumproduct tutorial will create soon. Also you can refer playlist where you may found lot of videos in which I have used array

Pls Show me sample data