Display the version of a document according to the status & Increment [Google Sheets]

Hello everyone,

I'm new to Google Sheets, and I'd like my document version to automatically refresh when the document status is "Draft".

If the document status is Draft then the version will be N/A. Otherwise, the user will manually enter the version.

Also, I would like the reference of the documents to be generated automatically from the "FO" prefixes and if the document belongs to a category, then the next number is the code of the category to which it belongs and then it is the increment.

FO-11: does not move
Example: FO-11-01 / FO-11-02...

https://docs.google.com/spreadsheets...it?usp=sharing

Thank you in advance for your help,

Have a nice day,

You need to make your file public.

googleaccess.JPG

If i understood you correctly;

- Enter this in cell C2 and drag down....

Please Login or Register  to view this content.

- Enter this in cell E2 and drag down...

Please Login or Register  to view this content.

Hello,

It's perfect ! Thank you !!
I'm new on Excel/Google Sheets and I have a question why using the IFERROR function ?
Also, is it possible to select cell into the match function ?

For example,

Please Login or Register  to view this content.

And also, if I'm changing +10 to 0, how to show P01 ? Because in this case the result is P1

Thank you for your help