User Profile
MJCalvin
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Lookup column based on "Created by" column
I have main list (image #1) for users to enter information, and the second list (image #2) with the users and their team name. In the main list, I like the Team column to be filled up automatically based on the "Created By" column. Can this be done with the native functions in a SharePoint list? Thanks! CalvinUse "List Validation" to make one of two columns mandatory
I have the following 3 columns. Budgeted: yes or no Approver: people field Lead_Approver: a dropdown field with emails What I tried to achieve is when the yes is selected in the Budgeted column, the "Approver" column will be mandatory while no is selected, the "Lead Approver" is mandatory. I could make one mandatory with the statement below but was not sure how to make both happened. =IF([Budgeted] = False,IF(ISBLANK([Lead_Approver]), false, true),true) Any help is appreciated. Thanks! CalvinCitrix Sharefile vs SharePoint for external collaboration
Hi, We have been using both Citrix Sharefile and SharePoint/Teams for many years but hesitated to completely replace ShareFile with SharePoint/Teams on external collaborations. The drive for this potential change is to save costs because SharePoint is already part of our M365 package. Currently Sharefile is used for external file sharing. We like it because it's extremely easy to manage both employees and guests, assign access and navigate from folder to folder. Low IT maintenance. SharePoint/Teams is used for internal collaboration most of the time. We have not allowed external sharing yet at tenant level for DLP reasons and the concern of lacking visibilities such as what files have been shared and who has access to any files at any given time. However, we do have some external sharing SharePoint/Teams sites but more work on IT team to set up Azure guest accounts upfront before they can be added to the SharePoint/Teams. Another disadvantage is the user experience that we need to navigate from site to site or one Teams to another. Not like Sharefile, it's just the folder structure. Let me know if you have run into the same situation and what would you do. Thank you! CalvinQuick questions before turning on Security Defaults
The current flow is whenever a new user is onboard, IT set up the computer in advance, sign in as the user to create the profile on PC including Office activation, Outlook profile and OneDrive for Business. Then the new user will just log in and everything is ready to go. Once we turned on Security Default, the MFA needs to be set up for the first time. IT probably should not be the one to do it. Can we turn MFA off on individual users for this purpose? or it's better to leave it to the new users? Thanks Calvin
