Do you have another video that explains how to have several different numbers in a single cell, and I only want some to increase while others are supposed to stay the same..? Sheets basically only increases the last number, automatically, and keeps anything before that same - no matter how many or what formats.
There is an easyer solution for the zero problem in column C : arrayformula(IF(A2:A="","","REF"&rept("0",5-LEN(A2:A))&A2:A)). Just repeat "0" 5 time minus length of a2:a
Great 👍🏼. The question is: Can we used this unique serial member as a key to update row data from another sheet ?! To clarify this. If I have filtered data in another sheet and want to edit value of a row in the master data. Is that possible 🤔🧐?
Hello! I think that the best solution will always be with GAS, pasting the new consecutive as a value. This works fine, but when you reorder, it will change the data. If you´d like we can do a video on this Regards!
Hey, great video but I am struggling with something a little more advanced. I am using one sheet for case management and I have different workstreams on the sheet, post, email, phone, in person etc. I have a drop down to select which but I only want to generate a reference number for phone. Is this possible?
@@practicalsheets In colum 'A' I have dropdowns. In Column B is for reference numbers. However, I want to manually input the reference numbers in all but 1 of the dropdown options. So if I chose 'Phone' from column 'A' I would like column B to auto populate a unique reference number
@@AllanFaddes Then you could use the code in this video: ruclips.net/video/Wb8aMIL0Idw/видео.html But in the conditions you would add a condition value=="Phone" so that it only works when you write phone
It is not easy with this example. I try to do it in another video but it is very complicated Maybe with the new function such as LAMBDA it will be easier Regards!
Do you have another video that explains how to have several different numbers in a single cell, and I only want some to increase while others are supposed to stay the same..? Sheets basically only increases the last number, automatically, and keeps anything before that same - no matter how many or what formats.
Have you tried using advanced formats?
Kind Regards
There is an easyer solution for the zero problem in column C : arrayformula(IF(A2:A="","","REF"&rept("0",5-LEN(A2:A))&A2:A)). Just repeat "0" 5 time minus length of a2:a
Very nice solution!
Thank you for sharing!
It is simpler. and more elegant!
Regards!
Great 👍🏼.
The question is:
Can we used this unique serial member as a key to update row data from another sheet ?!
To clarify this. If I have filtered data in another sheet and want to edit value of a row in the master data.
Is that possible 🤔🧐?
Hello!
I think that the best solution will always be with GAS, pasting the new consecutive as a value. This works fine, but when you reorder, it will change the data.
If you´d like we can do a video on this
Regards!
Hey, great video but I am struggling with something a little more advanced. I am using one sheet for case management and I have different workstreams on the sheet, post, email, phone, in person etc. I have a drop down to select which but I only want to generate a reference number for phone. Is this possible?
Hi!
I don´t think I fully understand how do you want to do it
Kind Regards
@@practicalsheets In colum 'A' I have dropdowns. In Column B is for reference numbers. However, I want to manually input the reference numbers in all but 1 of the dropdown options. So if I chose 'Phone' from column 'A' I would like column B to auto populate a unique reference number
@@AllanFaddes Then you could use the code in this video:
ruclips.net/video/Wb8aMIL0Idw/видео.html
But in the conditions you would add a condition value=="Phone" so that it only works when you write phone
Hello, I have a problem. Error #REF! How can I solve an iterative calculation?
Go to File>Settings>Calculation
Regards!
Actually I tried this formula but didn't work for me.
Gives me (3 arguements instead of 1 arguement) error
THANKS SO MUCH !
Thank you for commenting!
I wanna add ti this if c2:c = Grade 6 it show G6 like this how to add thi
It is not easy with this example. I try to do it in another video but it is very complicated
Maybe with the new function such as LAMBDA it will be easier
Regards!
There is an easier solution. CONCATENATE("REF", REPT("0", 6-LEN(ROW()-2)), ROW()-2) . Here I have given ROW()-2 because my data starts at row 3.