SharePoint Online: Calculated Column

Question

Hi,&nbsp;&nbsp;Looking for some advise on whether it's possible to achieve the following using a calculated column in a SharePoint list.&nbsp;&nbsp;Is it possible to use a formula to add each Downtime together? For example, 1507 + 153 = 1660 then 1660 + 20 = 1680...&nbsp;&nbsp;If this is possible, what would be the formula used to achieve this?&nbsp;&nbsp;

pamdegraffenreid · Answer

Matt_2022&nbsp; A calculate column will only sum fields in the same list item, not across multiple items.&nbsp; It sounds like you want a running total of downtime - you can do this with Power Automate.&nbsp; Is that right? If so, try this:&nbsp;Advanced | Flow of The Week: Calculate running totals and tracking maximum values in Flow | Power Automate Blog (microsoft.com)

Forum Discussion

SharePoint Online: Calculated Column

1 Reply