question

AjwadBukhari-7117 avatar image
0 Votes"
AjwadBukhari-7117 asked YiLu-MSFT commented

Sharepoint Lists Column Addition

So in the calculated column I created [Total Hours Worked], I want to add [Current Hours Worked] values and keep this value in the [Total Hours Worked] column so that when someone updates [Current Hours Worked] column the value will get updated automatically.

[Total Hours Worked] = [Total Hours Worked]+[Current Hours Worked]

But following error is raised.
The formula for a calculated column can't refer to the same calculated column.

I need a work around for this.

office-sharepoint-onlineoffice-sharepoint-server-development
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

YiLu-MSFT avatar image
0 Votes"
YiLu-MSFT answered YiLu-MSFT commented

Hi,@AjwadBukhari-7117

As a workaround, we suggest you create a column(Total Hours Worked1) first, then create the Calculated column( Total Hours Worked2),in this way you can use the formula:

[Total Hours Worked2] = [Total Hours Worked1]+[Current Hours Worked]

106830-case618.png




If an Answer is helpful, please click "Accept Answer" and upvote it.



Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



case618.png (43.7 KiB)
· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for the answer but I have another problem with this.

[Total Hours Worked2] = [Total Hours Worked1]+[Current Hours Worked]

Can [Total Hours Worked1] have value of [Total Hours Worked2] once [Total Hours Worked2] is update ?

Sharepoint is also not allowing

[Total Hours Worked1] = [Total Hours Worked2]

The formula contains a circular reference (the calculated column refers to itself). You must remove or change the circular reference

0 Votes 0 ·

No, this is conflict and will not work.

0 Votes 0 ·

Is there any other suggested method to work around this ?

0 Votes 0 ·
Show more comments