Date column automatically updates to a future date based on another date column

%3CLINGO-SUB%20id%3D%22lingo-sub-2426243%22%20slang%3D%22en-US%22%3EDate%20column%20automatically%20updates%20to%20a%20future%20date%20based%20on%20another%20date%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2426243%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20creating%20a%20SharePoint%20list%20which%20has%20a%20date%20column%20where%20team%20members%20will%20select%20the%20date%20that%20they%20attempted%20to%20contact%20a%20client.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20a%20second%20date%20column%20which%20will%20contain%20days%20that%20a%2060%20days%20from%20what%20has%20been%20entered%20in%20the%20previous%20column.%20This%20date%20is%20when%20we%20must%20attempt%20contact%20with%20that%20client%20again.%20I%20would%20like%20to%20know%20if%20there%20is%20a%20way%20to%20have%20this%20column%20automatically%20update%20to%20the%20required%20date%2C%20this%20will%20save%20a%20little%20bit%20of%20time%20for%20the%20team%20having%20to%20count%20the%20days%20out%20themselves.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2426243%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2426745%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20column%20automatically%20updates%20to%20a%20future%20date%20based%20on%20another%20date%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2426745%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F984913%22%20target%3D%22_blank%22%3E%40DBreezy92%3C%2FA%3E%26nbsp%3B-%20after%20you%20create%20the%20first%20column%2C%20maybe%20called%20'1st%20Contact'%2C%20create%20a%20calculated%20column%2C%20in%20the%20formula%20box%2C%20you'd%20enter%20%3D%5B1st%20Contact%5D%2B30.%20Make%20sure%20to%20format%20it%20as%20a%20date.%20Once%20that's%20in%20place%20you%20can%20add%20rules%20or%20power%20automate%20flows%20to%20remind%20folks.%20Or%20even%20just%20add%20some%20conditional%20formatting%20that%20turns%20fields%20red%20when%20it's%20time%20to%20reach%20back%20out.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi,

 

I am creating a SharePoint list which has a date column where team members will select the date that they attempted to contact a client.

 

There is a second date column which will contain days that a 60 days from what has been entered in the previous column. This date is when we must attempt contact with that client again. I would like to know if there is a way to have this column automatically update to the required date, this will save a little bit of time for the team having to count the days out themselves.

2 Replies

Hi @DBreezy92 - after you create the first column, maybe called '1st Contact', create a calculated column, in the formula box, you'd enter =[1st Contact]+30. Make sure to format it as a date. Once that's in place you can add rules or power automate flows to remind folks. Or even just add some conditional formatting that turns fields red when it's time to reach back out.

@DBreezy92 from the list settings just create a calculated column  and type = then select the column with the contacted date then type +60:

calcColumn.png

 

Rob
Los Gallardos
Intranet, SharePoint, Website and Power Platform Manager (and classic 1967 Morris Traveller driver)