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

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