Forum Discussion

Matt_2022

Copper Contributor

Jun 22, 2022

SharePoint Online: Calculated Column

Hi, Looking for some advise on whether it's possible to achieve the following using a calculated column in a SharePoint list. Is it possible to use a formula to add each Downtime together? ...

MVP

Jun 22, 2022

Matt_2022 A calculate column will only sum fields in the same list item, not across multiple items. It sounds like you want a running total of downtime - you can do this with Power Automate. Is that right? If so, try this:

Advanced | Flow of The Week: Calculate running totals and tracking maximum values in Flow | Power Automate Blog (microsoft.com)