SOLVED

SharePoint List - Calculated Column

%3CLINGO-SUB%20id%3D%22lingo-sub-2344422%22%20slang%3D%22en-US%22%3ESharePoint%20List%20-%20Calculated%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2344422%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20SharePoint%20list%20showing%20the%20following%3A%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%20image-alt%3D%22drishm13_0-1620737370785.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F279795i8BF0C4621633A34E%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22drishm13_0-1620737370785.png%22%20alt%3D%22drishm13_0-1620737370785.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20get%20another%20calculated%20column%20that%20shows%20the%20difference%20between%20the%20%22Expiry%20Month%22%20and%20%22Today%20Month%22%20but%20to%20show%20the%20difference%20like%20%226%20months%2C%203%20months%2C%205%20months%2C%20etc%22%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2344422%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESites%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2344580%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20-%20Calculated%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2344580%22%20slang%3D%22en-US%22%3EI%20don't%20think%20you%20can%20do%20that%20using%20the%20Standard%20Sharepoint%20list%20the%20preferred%20thing%20for%20this%20will%20be%20going%20toward%20PowerApps%20the%20low%20code%20no%20code%20option...%20where%20you%20could%20do%20logic%20and%20code%20behind%20the%20seen%20and%20you%20will%20be%20able%20to%20have%20that%20data%20in%20the%20Sharepoint%20list%20with%20help%20of%20Powerapps%20codes..%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

I have a SharePoint list showing the following:

 

drishm13_0-1620737370785.png

 

Is it possible to get another calculated column that shows the difference between the "Expiry Month" and "Today Month" but to show the difference like "6 months, 3 months, 5 months, etc"?

 

Thanks.

1 Reply
best response confirmed by drishm13 (New Contributor)
Solution
I don't think you can do that using the Standard Sharepoint list the preferred thing for this will be going toward PowerApps the low code no code option... where you could do logic and code behind the seen and you will be able to have that data in the Sharepoint list with help of Powerapps codes..