Hey everyone, I would like to change a cell value to e.g. "0" depending on a nother cell value/column. As I am not familiar with JSON I'm missing the code I could insert to get this feature. Looking forward to your help! Cheers Julian

Hi @Julian Paus Per my test, you can use following json formatting to set column value { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "txtContent": "=if([$Title] == 'Result A', '0','1')" } The json is to set current column value to 0 when Title column value is Result A , set column value to 1 when Title column value is not Result A . Here is the test result If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment" . 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.

Lists - How to change a cell value to 0 depending on a nother cell value/column.

Accepted answer

RaytheonXie_MSFT 33,641 Reputation points Microsoft Vendor

2023-03-06T02:14:48.22+00:00
Hi @Julian Paus

Per my test, you can use following json formatting to set column value

{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "txtContent": "=if([$Title] == 'Result A', '0','1')" }

The json is to set current column value to 0 when Title column value is Result A, set column value to 1 when Title column value is not Result A.

Here is the test result

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.
Please sign in to rate this answer.
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

RaytheonXie_MSFT 33,641 Reputation points Microsoft Vendor

2023-03-07T06:48:30.33+00:00

Hi @Julian Paus

Have you tried the solution I proposed?

If you have any questions or progress, you can contact me in time.

Looking forward to your reply

Have a lucky day!

Thanks,

Raytheon Xie

RaytheonXie_MSFT 33,641 Reputation points Microsoft Vendor

2023-03-08T02:55:39.19+00:00

Hi @Julian Paus

Would you tell me whether your issue has been resolved or have any update?

I am looking forward to your reply.

Have a nice day!

Thanks,

Raytheon Xie

Julian Paus 60 Reputation points

2023-03-08T20:45:08.02+00:00

Hey @RaytheonXie_MSFT

Thanks for your quick answer.
I just applied it and it worked well.

By trial and error I got the result I wanted.

As you see attached I wanted to have the numbers in the other cells, when status is not "Storniert". I did it by adding [$Anzahl] instead of 1. Thank you very much :-)

Cheers
Julian

RaytheonXie_MSFT 33,641 Reputation points Microsoft Vendor

2023-03-09T01:12:36.0333333+00:00

Hi @Julian Paus

Thanks for your time in advance.

I'm glad to hear you found the solution to this problem. Thanks for your sharing. If you have any issue about SharePoint in the future, you are welcome to raise a ticket in this forum.

Julian Paus 60 Reputation points

2023-03-24T15:33:00.44+00:00

Hi @RaytheonXie_MSFT
I got the following issue.
Attached the code again.

The shown value when it is "Storniert" is 0. But the calculated value in the cell is still the origin value. See attached. When I click on the cell value it shows the origin value and before it shows 0 in red. The issue is that the sum value in this column is still 11 and not 4+4+0=8. Do you know how to change the cell value in fact to the value I would like to have? In this case 0. Thank you in Advance.

Best

Julian

RaytheonXie_MSFT 33,641 Reputation points Microsoft Vendor

2023-03-27T02:03:36.9966667+00:00

Hi @Julian Paus

Thanks for letting us know your user experience. According to your case description, the summe should be a view and won't affected by column formatting. In your sample, the true value of Anzahl is 4,4,3 and the column formatting display the 4,4,0 in your list. But the true value hasn't been change. When you use sum function in the view. It will caculate the true value. It turns out to be a by-design one.

Julian Paus 60 Reputation points

2023-05-09T21:13:16.7033333+00:00

Hey @RaytheonXie_MSFT

Is there a chance with another code to change the cell value of one cell depending on another cell?
If the true value could be changed it would really help.

Thank you in advance.

Best

Julian
Sign in to comment

Share via

Lists - How to change a cell value to 0 depending on a nother cell value/column.

0 additional answers