SharePoint Online Code

Question

SharePoint Online Code

Tom N 21

Looking to create a code that looks at one column, and depending the value , sets a value in a second column.

Bascially when the District column location is entered , the Tech column will auto populate with the Tech name that covers that location

I used an If Statement that works with just one location added, but cannot figure out how to add all of them to the IF statement.

Dillon Silzer 57,826 Reputation points Volunteer Moderator

2022-10-01T22:29:33.297+00:00

Do you have access to PowerAutomate? This would be a much easier process instead of using an extremely large IF within an IF statement.

If you want to go down the IF route:

IF(logical_test,value_if_true,value_if_false)

Therefore, you can use the IF statement when FALSE to prep the next IF:

IF(col1="QHQ",dothis,IF(col1="District 1",dothis,IF(col1="District 2",dothis,etc)))

https://support.microsoft.com/en-us/office/if-function-7025be14-5665-43d0-af20-8293d1fe9d3a
Tom N 21 Reputation points

2022-10-02T00:50:06.44+00:00

I do have access to power automate, I havent used it , but would certainly give it a try.

Accepted answer

0 additional answers

Your answer

Dillon Silzer 57,826 Reputation points Volunteer Moderator

2022-10-01T22:29:33.297+00:00

Do you have access to PowerAutomate? This would be a much easier process instead of using an extremely large IF within an IF statement.

If you want to go down the IF route:

IF(logical_test,value_if_true,value_if_false)

Therefore, you can use the IF statement when FALSE to prep the next IF:

IF(col1="QHQ",dothis,IF(col1="District 1",dothis,IF(col1="District 2",dothis,etc)))

https://support.microsoft.com/en-us/office/if-function-7025be14-5665-43d0-af20-8293d1fe9d3a
Tom N 21 Reputation points

2022-10-02T00:50:06.44+00:00

I do have access to power automate, I havent used it , but would certainly give it a try.

Answer 1

Emily Du-MSFT 51,836 Microsoft External Staff

@Tom N

You could create a calculated column, then use following formula in the calculated column.

if(District="QHQ","Tom", if(OR(District="District3",District="District5",District="District6"),"Sue", if(District="District1", "Bill", if(District="District2", "Peter", "Liz"))))

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.

Emily Du-MSFT 51,836 Reputation points Microsoft External Staff

2022-10-05T08:48:45.953+00:00

@Tom N

I’m checking how the things are going on about this issue. Whether the answer helps you?

If there is any problem with this issue, feel free to let me know.

Share via

SharePoint Online Code

0 additional answers

Your answer