Sharepoint Listas Columna Autonumerada

%3CLINGO-SUB%20id%3D%22lingo-sub-999728%22%20slang%3D%22es-ES%22%3ESharepoint%20Lists%20Self-numbered%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-999728%22%20slang%3D%22es-ES%22%3E%3CP%3EGood%20morning%2C%20everybody.%20You%20would%20need%20to%20create%20a%20list%20in%20which%20there%20is%20a%20column%20that%20concatenates%20the%20first%20letter%20of%202%20previous%20columns%20and%20performs%20consecutive%20numbering.%20I%20leave%20you%20with%20an%20image%20of%20what%20this%20necessary%20numbering%20would%20be%20like.%20That%20is%20to%20say%20I%20would%20need%20an%20index%20for%20every%20combination%20of%20letters%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20261px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F156128i27EE3712A89D2E5C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22No%20title.%20png%22%20title%3D%22Sin%20t%C3%ADtulo.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20guess%20I%20should%20use%20some%20formula.%3C%2FP%3E%3CP%3ECan%20someone%20help%20me%3F%3C%2FP%3E%3CP%3EBest%20regards%3C%2FP%3E%3CP%3EDiego%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-999728%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1003370%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Listas%20Columna%20Autonumerada%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1003370%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F454213%22%20target%3D%22_blank%22%3E%40dnunez%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20use%20the%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fconcatenate-function-5b0392b2-94ef-49ea-8532-4fdd3a69d362%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ECONCATENATE%3C%2FA%3E%20function%20inside%20of%20a%20Calculate%20column%20that%20references%20the%20ID%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F156578i3525E92FE25F9B8A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ERes%3C%2FSTRONG%3E%20%3DCONCATENATE(A%2CB%2CID)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENorm%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Buenas a todos. Necesitaria crear una lista en la cual exista una columna que concatene la primer letra de 2 columnas anteriores y realice una numeración consecutiva. Les dejo una imagen de como sería esta numeracion necesaria. Es decir que necesitaria un indice por cada combinacion de letras

 

Sin título.png

Supongo debo usar alguna formula.

Alguien me podrá ayudar?

Saludos

Diego

1 Reply

Hi @dnunez,

 

You can use the CONCATENATE function inside of a Calculate column that references the ID column.

 

clipboard_image_0.png

 

Res =CONCATENATE(A,B,ID)

 

I hope this helps.

 

Norm