Let's say I have two columns in a SharePoint list: [Invoice Age] - text (20, 23, 25) [Payment Status] - text (Not Paid, Paid) I'd like to create a calculated column [Invoice Age] that will increase by 1 everyday assuming the [Payment Status] for that row is not updated to a specific value like "Paid." If the [Payment Status] for that row is updated to "Paid" then the [Invoice Age] will reset to 0 and increase by 1. For example, a row with a [Invoice Age] of 15 will increase by 1 daily. So, tomorrow the column will reflect 16 and so on until the [Payment Status] is changed to "Paid" upon which the [Invoice Age] will go back to 0. I don't know how complicated the above ask is but any insight/guidance will be appreciated.