Calculated Date Field

%3CLINGO-SUB%20id%3D%22lingo-sub-1518936%22%20slang%3D%22en-US%22%3ECalculated%20Date%20Field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1518936%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20two%20SharePoint%20lists%20(let's%20call%20them%20List1%20and%20List2).%20List1%20is%20used%20to%20create%20events.%20List2%20is%20used%20to%20schedule%20meetings%20in%20those%20events%2C%20so%20List2%20has%20two%20columns%20(Event%20and%20Date)%20that%20are%20linked%20to%20List1.%20Once%20you%20choose%20an%20Event%20in%20List2%2C%20the%20date%20will%20automatically%20be%20pulled%20from%20List1.%20What%20I%20want%20to%20do%20is%20use%20the%20Date%20column%20that%20is%20linked%20to%20List1%20to%20automatically%20calculate%20the%20date%20when%20entering%20new%20meetings%20and%20then%20you%20just%20have%20to%20enter%20the%20time.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20in%20the%20form%20to%20create%20a%20new%20meeting%20you%20first%20choose%20the%20Event%20from%20a%20dropdown%20list.%20The%20date%20field%20in%20the%20form%20will%20be%20automatically%20filled%20in%20and%20then%20you%20just%20have%20to%20choose%20a%20time.%20Basically%20I%20am%20trying%20to%20avoid%20having%20to%20enter%20the%20date%20twice.%20I%20tried%20just%20creating%20my%20own%20dropdown%20list%20with%20times%2C%20but%20unless%20you%20do%20military%20time%20I%20don't%20see%20a%20way%20to%20sort%20properly.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eany%20ideas%3F%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1518936%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Lists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1520454%22%20slang%3D%22en-US%22%3ERe%3A%20Calculated%20Date%20Field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1520454%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F413847%22%20target%3D%22_blank%22%3E%40jalward%3C%2FA%3E%26nbsp%3Bwhich%20version%20of%20SharePoint%20you%20are%20using%3F%20This%20is%20something%20not%20possible%20with%20SharePoint%20OOB%20functionalities.%20So%2C%20have%20you%20to%20go%20with%20some%20customization's.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20are%20using%20on-premises%20version%20you%20can%20using%20SharePoint%20REST%20APIs%2FJSOM%20or%20if%20you%20are%20using%20SharePoint%20Online%20then%20you%20can%20customize%20the%20list%20forms%20using%20Power%20Apps.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1521639%22%20slang%3D%22en-US%22%3ERe%3A%20Calculated%20Date%20Field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1521639%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F373269%22%20target%3D%22_blank%22%3E%40ganeshsanap%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20use%20SharePoint%20online.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I have two SharePoint lists (let's call them List1 and List2). List1 is used to create events. List2 is used to schedule meetings in those events, so List2 has two columns (Event and Date) that are linked to List1. Once you choose an Event in List2, the date will automatically be pulled from List1. What I want to do is use the Date column that is linked to List1 to automatically calculate the date when entering new meetings and then you just have to enter the time. 

 

So in the form to create a new meeting you first choose the Event from a dropdown list. The date field in the form will be automatically filled in and then you just have to choose a time. Basically I am trying to avoid having to enter the date twice. I tried just creating my own dropdown list with times, but unless you do military time I don't see a way to sort properly. 

 

any ideas???

2 Replies

@jalward which version of SharePoint you are using? This is something not possible with SharePoint OOB functionalities. So, have you to go with some customization's.

 

If you are using on-premises version you can using SharePoint REST APIs/JSOM or if you are using SharePoint Online then you can customize the list forms using Power Apps. 

@ganeshsanap 

 

We use SharePoint online.