Is it possible in sharepoint if a choice is choosen can change the date accordingly

%3CLINGO-SUB%20id%3D%22lingo-sub-1852772%22%20slang%3D%22en-US%22%3EIs%20it%20possible%20in%20sharepoint%20if%20a%20choice%20is%20choosen%20can%20change%20the%20date%20accordingly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1852772%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20in%20teh%20process%20of%20creating%20a%20sharepoint%20list%20to%20get%20data%20about%20the%20supplier%20raw%20mataerial%20supply.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELest%20say%20we%20have%203%20kinds%20of%20material%2C%26nbsp%3B%20A%2CB%2CC%3C%2FP%3E%3CP%3Eand%20these%203%20material%20has%20different%20material%20arrival%20time%2C%20example%2C%20if%20A%20%3D%20Material%20arrive%20in%203%20days%2C%20B%3DMaterial%20arrive%20in%202%20days%2C%20C%3D%20Material%20arrive%20in%204%20days.%3C%2FP%3E%3CP%3Eis%20it%20possible%2C%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20A%20is%20choosen%20on%20Material%20column%2C%20i%20was%20thinking%20something%20like%20automatically%20on%20the%20date%20column%203%20days%20from%20today%20is%20selected.%3C%2FP%3E%3CP%3Eif%20B%20is%20choosen%20on%20Material%20column%2C%20automatically%20on%20the%20date%20column%202%20days%20from%20today%20is%20selected.%3C%2FP%3E%3CP%3Eif%20C%20is%20choosen%20on%20Material%20column%2C%20automatically%20on%20the%20date%20column%204days%20from%20today%20is%20selected.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eis%20such%20thing%20possible%20to%20do%20in%20sharepoint%20list%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1852772%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%3CLINGO-SUB%20id%3D%22lingo-sub-1855887%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20it%20possible%20in%20sharepoint%20if%20a%20choice%20is%20choosen%20can%20change%20the%20date%20accordingly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1855887%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F763131%22%20target%3D%22_blank%22%3E%40Vinoth40%3C%2FA%3E%20You%20should%20be%20able%20to%20do%20that%20using%20Calculated%20Column%20Formulas.%20Here%20is%20a%20link%20to%20a%20reference%20that%20might%20help%20you%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fprevious-versions%2Foffice%2Fdeveloper%2Fsharepoint-2010%2Fbb862071(v%3Doffice.14)%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fprevious-versions%2Foffice%2Fdeveloper%2Fsharepoint-2010%2Fbb862071(v%3Doffice.14)%26nbsp%3B%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERegards%2C%20Magnus%3C%2FP%3E%3C%2FLINGO-BODY%3E
Frequent Visitor

Hi All,

 

I am in teh process of creating a sharepoint list to get data about the supplier raw mataerial supply.

 

Lest say we have 3 kinds of material,  A,B,C

and these 3 material has different material arrival time, example, if A = Material arrive in 3 days, B=Material arrive in 2 days, C= Material arrive in 4 days.

is it possible, 

if A is choosen on Material column, i was thinking something like automatically on the date column 3 days from today is selected.

if B is choosen on Material column, automatically on the date column 2 days from today is selected.

if C is choosen on Material column, automatically on the date column 4days from today is selected.

 

is such thing possible to do in sharepoint list?

1 Reply

@Vinoth40 You should be able to do that using Calculated Column Formulas. Here is a link to a reference that might help you: https://docs.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/bb862071(v=offic...

 

Regards, Magnus