This is kinda difficult to explain...
Is it possible to let Google Sheets tell me what the maximum value is from some chosen columns in MORE THAN ONE sheet (in the same document)?
I namely need to find the largest occurrence of an id.
I would like to have a column that contains unique row ids. But I have different sheets in the document. So when I add a new row in one of the sheets, I would like to add the lowest id available (that is, an id one step larger than the currently maximum id).
But how can I find the next possible id in the sequence of ids that are already in use?
Now, instead of me having to look through all sheets, I would like to be able to find the next value for the cell automatically. E.g. by having it written in a cell in the corner of the sheet, or whatever. Then I can insert in manually. I just want to avoid LOOKING for it manually. Can that be done?
A bonus feature would of course be, if I can give the ids a prefix - e.g.
R134 instead of just
134. This means that a perfect solution of course would be, if the ids don't have to be all numeric.