lookup value base on condition from another columns in the same list

%3CLINGO-SUB%20id%3D%22lingo-sub-2798288%22%20slang%3D%22en-US%22%3Elookup%20value%20base%20on%20condition%20from%20another%20columns%20in%20the%20same%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2798288%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%3C%2FP%3E%3CP%3EI'm%20new%20at%20SharePoint%20List%20and%20I've%20an%20List%20that%20collect%20daily%20production%20data%20base%20on%20counter%20from%20machin.%3C%2FP%3E%3CP%3EMy%20columns%20in%20the%20list%20is%20%5BCOUNTER%5D%2C%5BMACHIN%5D%2C%5BMOLD_NUM%5D%2C%5BWORK_ORDER%5D.%3C%2FP%3E%3CP%3EI%20want%20to%20add%20an%20column%20that%20in%20the%20row%20will%20lookup%20the%20%5BCOUNTER%5D%20for%20the%20same%20%5BMACHIN%5D%2C%5BMOLD_NUM%5D%2C%5BWORK_ORDER%5D%20from%20the%20last%20time%20I've%20dot%20the%20data%20to%20the%20new%20column%2C%20if%20there%20is%20no%20data%20in%20the%20new%20column%20will%20be%200.%3C%2FP%3E%3CP%3ECan%20I%20do%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2798288%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello!

I'm new at SharePoint List and I've an List that collect daily production data base on counter from machin.

My columns in the list is [COUNTER],[MACHIN],[MOLD_NUM],[WORK_ORDER].

I want to add an column that in the row will lookup the [COUNTER] for the same [MACHIN],[MOLD_NUM],[WORK_ORDER] from the last time I've dot the data to the new column, if there is no data in the new column will be 0.

Can I do it?

0 Replies