jsasiadek35
New Member
- Joined
- Oct 21, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
A | B | D | F | |
Permission | Access | Permission | Access | |
Can Edit Sku Information | Warehouse User | Can Create Freight Moves | Linehaul Control | |
Can Import | Warehouse User,Power User | Can Edit Facility Address | TSA Group | |
Can Make Return Labels | Power User | Can Edit Sku Information | Warehouse User | |
Can Manage Skus Fulfillment | Direct | Can Import | Warehouse User | |
Can Adjust Inventory Levels | Direct | Can Process | Warehouse User | |
Can Process | Warehouse User,Power User | Can Receive Remote Crossings | Linehaul Control | |
Can Receive Remote Crossings | Linehaul Control | Can Set Known Shipper | TSA Group | |
Can Set Known Shipper | TSA Group | Can Unprocess | Warehouse User | |
Can Unprocess | Power User,Warehouse User | Can Use Operations Features (Standard) | Warehouse User | |
Can Use Operations Features (Standard) | Power User,Warehouse User | Create Shipments | Warehouse User | |
Create Linehaul | Power User | See All Entity Clients | Linehaul Control | |
Create Shipments | Warehouse User,Power User | See Freight Management System | Linehaul Control | |
2 | See Shipments | Warehouse User,Linehaul Control |
For example "Can process" would be a match and the difference between the Accesses would be the left user has Power User access that is different from the user on the right.
I am using google sheets which is not too great but for the first part matching the permissions I have:
=IF(COUNTIF($D:$D, $A2)=0, "User 2 does not have permission:", "Both users have permission:")
Having issues first off just comparing the cells with the delimited commas to each other for the difference
Then being able to incorporate it into the first formula so when it does find the match it will then find the difference between the access if any.
Any help would be appreciated as I've been stuck trying different things for numerous hours and can't seem to piece it together