I need to record number of points for each seminar attended [points received] and the points remaining [points remaining].
For example, for attending each seminar I get 2 points and the total number of points to receive is 15. So after I attend one seminar, I have 13 points remaining, after I attend the 2nd seminar, I have 11 points remaining, etc.
Is it possible to have a calculated column in SharePoint list to display this information?
I tried the following formula for the points remaining = 15 - [points received]
, but it always gives me 13 points in the [points remaining] column.
I also tried = [points remaining] - [points received]
, this gives me an error:
"The formula contains a circular reference (the calculated column refers to itself)."
Could you please provide any suggestions? If a calculated column is not an option here, what else I could use to achieve the task of recording this information in a list?
Thank you in advance.