Oct 01 2020 04:13 AM
Hello everyone,
I don't know if it is possible but I have 2 columns, in a Sharepoint Library:
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!
Oct 03 2020 06:21 AM
@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
Oct 05 2020 09:04 AM
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.
Oct 05 2020 09:04 AM
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.