Sharepoint Online Calculated Formulas

-

 

1. Number of days Calculation from the Date


Json

{

  "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",

  "elmType": "div",

  "txtContent": "=floor((Number(@now)-Number([$In_x0020_Project_x002f_Pool_x002]))/(1000 * 60 * 60 * 24))"

}



2. Total Exp calculation from the Date of Joining 


=IF(ISBLANK(DOJ),"",ROUND((INT((DATEDIF(DOJ,TODAY(),"D")-MOD(DATEDIF(DOJ,TODAY(),"D"),365))/365)+(INT(MOD(DATEDIF(DOJ,TODAY(),"D"),365)/30.44)/12))+[Exp Since DOJ (Y)],1))



Comments

Post a Comment

Popular posts from this blog

SPFX setup & deployment

-
  Setting up SharePoint Framework (SPFx) for SharePoint Online involves several steps. Below is a guide to help you set up SharePoint Framework for SharePoint Online compatibility: Note: please refer below link to get latest update https://learn.microsoft.com/en-us/sharepoint/dev/spfx/set-up-your-development-environment Prerequisites: Node.js and npm: Ensure you have Node.js installed. You can download it from nodejs.org . spfx support version => node-v18.17.1-x64 npm and yomen -> >npm install -g yo gulp >npm install -g @microsoft/generator-sharepoint SPFx generally works with the LTS (Long-Term Support) version of Node.js. Yeoman and Gulp: Install Yeoman and Gulp globally using npm. bash Copy code npm install -g yo gulp SharePoint Online Tenant Configuration: Developer Site: Create a developer site collection in your SharePoint Online tenant. This site collection is used for testing your SPFx web parts. App Catalog: Create an App Catalog site collection in your SharePo...
Read more

Sites.Selected | Graph API SharePoint Permission

-
Image
  SharePoint Site Collection Permission   The "sites.selected" permission in Microsoft Graph API allows you to grant an application access to specific SharePoint sites instead of all SharePoint sites in the tenant.   Step1: To   Configure "Sites.Selected" Permission in Azure App Registration To use "sites.selected" , you need to: Register an App in Azure AD . Grant "Sites.Selected" Permission to the app. Manually Grant Access to the specific SharePoint site. Use Microsoft Graph API or PowerShell to assign the required role (Read/Write).   Step 1: Register an App in Azure AD Go to Azure Portal → Azure Active Directory → App Registrations . Click New registration . Provide a name (e.g., SharePointAccessApp). Choose Accounts in this organizational directory only . Click Register . Step 2: Add "Sites.Selected" API Permission Navigate ...
Read more

Configure the SharePoint Online App Catalog

-
Image
  You can create an Sharepoint Online app catalog site collection in few simple steps: Sign into Office 365 as a global admin or SharePoint admin. Select the app launcher icon   in the upper left and choose  Admin  to open the Office 365 admin center (if you don’t see the Admin tile, you don’t have Office 365 administrator permissions in your organization). In the left pane, choose  Admin centers  >  SharePoint .  Click on  ‘More Features’  from the left navigation/pane. Now, click on the  ‘Open’  button under Apps. Select  apps  in the left pane, and then select  App Catalog. Select  Create a new Sharepoint app catalog site , and then select  OK . On the Create App Catalog Site Collection page, enter the required information, and then select  OK . An app catalog site collection has been created.  Once the App Catalog site collection is created successfully, click on the new link to th...
Read more