SOLVED

Calculated Date column based on a Date from another list

%3CLINGO-SUB%20id%3D%22lingo-sub-1354825%22%20slang%3D%22en-US%22%3ECalculated%20Date%20column%20based%20on%20a%20Date%20from%20another%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1354825%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%3C%2FP%3E%3CP%3EI%20am%20new%20to%20this%20forum.%20I%20started%20with%20Sharepoint%20a%20month%20ago%20and%20I%20have%20a%20question%20as%20I%20was%20guided%20to%20this%20site%20and%20would%20really%20appreciate%20your%20help%20on%20the%20below%20matter.%20I%20was%20wondering%20if%20Sharepoint%20List%20can%20perform%20basic%20automatic%20formulas%20as%20excel.%20%26nbsp%3BBelow%20is%20the%20description%20%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20created%20%3A%3C%2FP%3E%3CP%3EA-%20List%20A%20(%20only%20one%20item)%20%26nbsp%3Bwith%20a%20Date%20column%20%22Start%22%20%26nbsp%3B%3C%2FP%3E%3CP%3EB-%20List%20B%20(%20several%20items)%20with%20a%20Date%20column%20%22Deadlines%22%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20following%20is%20targeted%20%3A%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3EThat%20Deadline%20in%20List%20B%20will%20be%3CSTRONG%3E%20automatically%20populated%3C%2FSTRONG%3E%20once%20%22Start%22%20in%20List%20A%20is%20filled%2Fedited%20as%20per%20below.%20%3CFONT%20color%3D%22%23808080%22%3E%3CEM%3E%26nbsp%3BThe%20user%20will%20only%20input%20only%20one%20data%20which%20is%20%22Start%22.%26nbsp%3B%3C%2FEM%3E%3C%2FFONT%3E%3C%2FLI%3E%3C%2FOL%3E%3CUL%3E%3CLI%3EItem_1_Deadline%20%3D%20%22Start%22%20%2B7%20days%26nbsp%3B%3C%2FLI%3E%3CLI%3EItem_2_Deadline%3D%26nbsp%3B%22Start%22%20%2B%2014%20days%26nbsp%3B%3C%2FLI%3E%3CLI%3EItem_3_Deadline%20%3D%22Start%22%2B%2021%20days%26nbsp%3B%3C%2FLI%3E%3C%2FUL%3E%3CP%3EI%20tried%20with%20lookup%20column%2C%20however%20lookup%20column%20does%20not%20automatically%20fill%2Fpopulate%20a%20column%20in%20Sharepoint%2C%20additionally%20it%20is%20not%20possible%20to%20execute%20a%20formula%20with%20a%20Lookup%20column%20values.%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20it%20is%20possible%20with%20json%20code%20formatting%20%2C%20I%20would%20appreciate%20guidance%20on%20where%20I%20can%20get%20the%20info.%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20help%20is%20highly%20appreciated.%20And%20If%20you%20require%20additional%20information%20%26nbsp%3BI%20am%20more%20than%20available%20to%20provide%20it%20.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%26nbsp%3B%3C%2FP%3E%3CP%3ENajwa.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1354825%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1355445%22%20slang%3D%22en-US%22%3ERe%3A%20Calculated%20Date%20column%20based%20on%20a%20Date%20from%20another%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1355445%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F610669%22%20target%3D%22_blank%22%3E%40Najwa_Work%3C%2FA%3E%26nbsp%3Byou%20can%20use%20PowerAutomate%20or%20a%20SharePoint%20Designer%20Workflow%20(that's%20the%20old%20way).%20Trigger%20when%20a%20new%20item%20is%20created%20in%20List%20A%20and%20then%20use%20the%20Flow%20to%20create%203%20items%20in%20the%20second%20list.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOne%20thing%20to%20consider%20is%20the%20number%20of%20items%20that%20may%20get%20generated%20in%20List%20B.%20If%20all%20of%20the%20dates%20relate%20to%20the%20same%20item%2C%20then%20you%20may%20be%20better%20just%20having%20the%203%20dates%20in%20List.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1355757%22%20slang%3D%22en-US%22%3ERe%3A%20Calculated%20Date%20column%20based%20on%20a%20Date%20from%20another%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1355757%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%2F43161%22%20target%3D%22_blank%22%3E%40Steve%20Knutson%3C%2FA%3E%26nbsp%3B%2C%20Thank%20you%20for%20your%20help%20I%20will%20use%20the%20new%20Flow%20of%20PowerAutomate.%26nbsp%3B%3C%2FP%3E%3CP%3EThx.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENajwa.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello All,

I am new to this forum. I started with Sharepoint a month ago and I have a question as I was guided to this site and would really appreciate your help on the below matter. I was wondering if Sharepoint List can perform basic automatic formulas as excel.  Below is the description : 

 

I have created :

A- List A ( only one item)  with a Date column "Start"  

B- List B ( several items) with a Date column "Deadlines" 

 

The following is targeted : 

  1. That Deadline in List B will be automatically populated once "Start" in List A is filled/edited as per below.  The user will only input only one data which is "Start". 
  • Item_1_Deadline = "Start" +7 days 
  • Item_2_Deadline= "Start" + 14 days 
  • Item_3_Deadline ="Start"+ 21 days 

I tried with lookup column, however lookup column does not automatically fill/populate a column in Sharepoint, additionally it is not possible to execute a formula with a Lookup column values. 

if it is possible with json code formatting , I would appreciate guidance on where I can get the info. 

Your help is highly appreciated. And If you require additional information  I am more than available to provide it . 

 

Thank you. 

Najwa. 

 

2 Replies
best response confirmed by Najwa_Work (Occasional Contributor)
Solution

@Najwa_Work you can use PowerAutomate or a SharePoint Designer Workflow (that's the old way). Trigger when a new item is created in List A and then use the Flow to create 3 items in the second list.

 

One thing to consider is the number of items that may get generated in List B. If all of the dates relate to the same item, then you may be better just having the 3 dates in List. 

HI @Steve Knutson , Thank you for your help I will use the new Flow of PowerAutomate. 

Thx. 

 

Najwa.