Forum Discussion
FlowTime1990
Dec 02, 2023Brass Contributor
Years Of Experience Calculation
I have a SharePoint list which I calculated the years of experience at the time of Request. So on the first line I calculated 15.03 on 11/09/2023. I would like to add another YOE (years of experien...
Dec 03, 2023
Hi FlowTime1990 - the only issue with using a Calculated column is that they're static. The calculations against Today will only happen when a line item is modified. You could create a Power Automate flow to run daily, do the math and then write to the number of years back to the columns.