Using Calculated columns in MS Lists

Copper Contributor

How can i make a calculated in column or columns to track time between changes in selection to a specific column?


For example when Status column is changed from Inquiry to Negotiating i need a column that will tell me the day that happened. Then when it changes from Negotiating to Executed i need another column that will tell me that date. This way i will be able to track the amount of days it takes status to move from inquiry to negotiating to executed 

2 Replies

@anon123456 you'll need to do this with a flow in Power Automate, it won't be possible with just formulas in SharePoint.


Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

@Rob_Elliott thanks for that info, how would i go about doing that? i have never used power automate before