Hi Team, I'm trying to integrate an IF(AND statement into an existing IF statement which works for my SharePoint list header. I want it to return this value if "Is a Change Manager required?" = 'Yes' and "Assigned Change Manager" ='blank', then for it to return "Bus Metro Change Contact: Resource TBC" , and if false to return "Bus Metro Change Contact: " I'll provide the column names so there's confusion and the existing JSON coding where the IF formula is, I need to keep active. Field Column name Is a Change Manager required? Is_x0020_a_x0020_Change_x0020_Ma Assigned Change Manager Assigned_x0020_Change_x0020_Mana Existing JSON Coding under "txtContent" "elmType": "span", "attributes": { "class": " ms-fontColor-white ms-fontWeight-bold ms-fontSize-12" }, "txtContent": "=if([$Is_x0020_a_x0020_Change_x0020_Ma] =='No','Bus Metro Change Contact: Not Required','Bus Metro Change Contact: ')" Look forward to your response team. Regards, Harry

Here are JSON codes for you: "elmType": "span", "attributes": { "class": "ms-fontColor-white ms-fontWeight-bold ms-fontSize-12" }, "txtContent": "=if (([$Is_x0020_a_x0020_Change_x0020_Ma] == 'No')||([$Assigned_x0020_Change_x0020_Mana] != ''), 'Bus Metro Change Contact:', 'Bus Metro Change Contact:Resource TBC')" 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.

SharePoint List Header-JSON coding for IF and statement

Field	Column name
Is a Change Manager required?	Is_x0020_a_x0020_Change_x0020_Ma
Assigned Change Manager	Assigned_x0020_Change_x0020_Mana

Accepted answer

Emily Du-MSFT 46,171 Reputation points Microsoft Vendor

2023-09-28T06:39:31.4266667+00:00
Here are JSON codes for you:

"elmType": "span", "attributes": { "class": "ms-fontColor-white ms-fontWeight-bold ms-fontSize-12" }, "txtContent": "=if (([$Is_x0020_a_x0020_Change_x0020_Ma] == 'No')||([$Assigned_x0020_Change_x0020_Mana] != ''), 'Bus Metro Change Contact:', 'Bus Metro Change Contact:Resource TBC')"

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.
Harry N Nomikos 1,311 Reputation points

2023-09-28T13:35:28.86+00:00

Hi @Emily Du-MSFT

I want to combine these 2 if statements under txtContent: section
Cheers,
Harry

"elmType": "span", "attributes": { "class": " ms-fontColor-white ms-fontWeight-bold ms-fontSize-12" }, "txtContent": "=if (([$Is_x0020_a_x0020_Change_x0020_Ma] == 'No')||([$Assigned_x0020_Change_x0020_Mana] != ''), 'Bus Metro Change Contact: Not Required', 'Bus Metro Change Contact: ',if (([$Is_x0020_a_x0020_Change_x0020_Ma] == 'Yes')||([$Assigned_x0020_Change_x0020_Mana] != ''), 'Bus Metro Change Contact: Resource TBC', 'Bus Metro Change Contact: ' ))" ```

Emily Du-MSFT 46,171 Reputation points Microsoft Vendor

2023-09-29T05:57:42.1+00:00

1.[$Is_x0020_a_x0020_Change_x0020_Ma] == 'No')||([$Assigned_x0020_Change_x0020_Mana] != ''

It is true when meet one of the conditions, "Is a Change Manager required?" field is equal to No or "Assigned Change Manager" field is not blank.

2.[$Is_x0020_a_x0020_Change_x0020_Ma] == 'Yes')||([$Assigned_x0020_Change_x0020_Mana] != ''

It is true when meet one of the conditions, "Is a Change Manager required?" field is equal to Yes or "Assigned Change Manager" field is not blank.

3.These two IF statements are conflicted, cannot be combined.

4.The IF statement provided in my answer meets your requirement in the original post. If you have any other requirement, please feel free to tell me.

Harry N Nomikos 1,311 Reputation points

2023-09-30T12:00:27.13+00:00

Hi @Emily Du-MSFT

Apologies if wasn't clear from the start.

I'm after 2 if statements to meet the below criteria and I'd like for it be integrated as one nested if statement (if possible):

Is a Change Manager required?" = 'No' and "Assigned Change Manager" ='blank', then for it to return "Bus Metro Change Contact: No Resource Required", and if false to return "Bus Metro Change Contact: "

Is a Change Manager required?" = 'Yes' and "Assigned Change Manager" ='blank', then for it to return "Bus Metro Change Contact: Resource TBC", and if false to return "Bus Metro Change Contact: "

Field names:

[$Is_x0020_a_x0020_Change_x0020_Ma] & ([$Assigned_x0020_Change_x0020_Mana]

If they can't be combined with using an IF(AND condition, is there another work around?

Regards,
Harry

Emily Du-MSFT 46,171 Reputation points Microsoft Vendor

2023-10-02T02:33:41.29+00:00

Try below formula.

"txtContent": "=if(([$Is_x0020_a_x0020_Change_x0020_Ma] == 'No')&&([$Assigned_x0020_Change_x0020_Mana] == ''), 'Bus Metro Change Contact: No Resource Required', if(([$Is_x0020_a_x0020_Change_x0020_Ma] == 'Yes')&&([$Assigned_x0020_Change_x0020_Mana] == ''),'Bus Metro Change Contact: Resource TBC', 'Bus Metro Change Contact:'))"

Harry N Nomikos 1,311 Reputation points

2023-10-02T06:04:27.2933333+00:00

Thank you @Emily Du-MSFT the above formula worked :)

Emily Du-MSFT 46,171 Reputation points Microsoft Vendor

2023-10-02T06:06:26.2766667+00:00

If you find any answer helpful to you, please remember to accept it.

Thank you.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

SharePoint List Header-JSON coding for IF and statement

0 additional answers

Your answer