SOLVED

change column value depending on another column value

%3CLINGO-SUB%20id%3D%22lingo-sub-1733991%22%20slang%3D%22en-US%22%3Echange%20column%20value%20depending%20on%20another%20column%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1733991%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20know%20if%20it%20is%20possible%20but%20I%20have%202%20columns%2C%20in%20a%20Sharepoint%20Library%3A%3C%2FP%3E%3CUL%3E%3CLI%3EColumn%201%20with%203%20choices%3A%20Refused%2C%20Accepted%2C%20Studied%3C%2FLI%3E%3CLI%3EColumn%202%20with%203%20choices%3A%20Waiting%2C%20In%20progress%2C%20Treated%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20an%20user%20chooses%20%22accepted%22%20or%20%22studied%22%20in%20column%201%2C%20I%20want%20the%20column%202%20to%20automatically%20turn%20on%20%22In%20progress%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20do%20this%20with%20a%20formula%20or%20a%20method%20in%20Sharepoint%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1733991%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2013%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1742077%22%20slang%3D%22en-US%22%3ERe%3A%20change%20column%20value%20depending%20on%20another%20column%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1742077%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F724891%22%20target%3D%22_blank%22%3E%40Alexxx650%3C%2FA%3E%26nbsp%3BI%20noticed%20that%20the%20labels%20for%20this%20thread%20mentioned%202013%20so%20I%20assume%20you%20are%20using%20SharePoint%202013.%20If%20you%20were%20using%20SharePoint%20Online%20I%20would%20have%20suggested%20using%20a%20PowerApps-customized%26nbsp%3B%20SharePoint%20form%20where%20you%20can%20easily%20change%20a%20value%20in%20a%20column%20based%20on%20a%20value%20in%20another.%20But%20you%20might%20want%20to%20look%20at%20doing%20it%20with%20a%20flow%20in%20Power%20Automate%20so%20that%20when%20an%20item%20in%20a%20SharePoint%20list%20is%20updated%20it%20sets%20the%20relevant%20columns%20to%20the%20value%20you%20want.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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 Replies
Highlighted

@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

Highlighted
Best Response confirmed by Alexxx650 (Occasional Contributor)
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.