change column value depending on another column value

[Alexxx650]

Hello everyone,

I don't know if it is possible but I have 2 columns, in a Sharepoint Library:

• Column 1 with 3 choices: Refused, Accepted, Studied
• Column 2 with 3 choices: Waiting, In progress, Treated

If an user chooses "accepted" or "studied" in column 1, I want the column 2 to automatically turn on "In progress".

Is it possible to do this with a formula or a method in Sharepoint?

Thanks!

[#2]

@Alexxx650 I noticed that the labels for this thread mentioned 2013 so I assume you are using SharePoint 2013. If you were using SharePoint Online I would have suggested using a PowerApps-customized  SharePoint form where you can easily change a value in a column based on a value in another. But you might want to look at doing it with a flow in Power Automate so that when an item in a SharePoint list is updated it sets the relevant columns to the value you want.

Rob
Los Gallardos
Microsoft Power Automate Community Super User

[#3 · Accepted solution]

@Alexxx650 I would do it with flow as that would make it independent of how people edit the document metadata. They could use the form, information details or quick edit and the flow would still work.