5 votes
Accepted

Calculated Column Based off of a Date & Time Field

Create a new calculated column & use formula in below format: =DATE(YEAR([Onboarding Date]) + 1, MONTH([Onboarding Date]), DAY([Onboarding Date])) Documentation: Calculated Field Formulas - Date ...
user avatar
  • 28.2k
4 votes
Accepted

How to change site URL on SharePoint 2019 server

You can use AAM(alternate access mappings) to achieve it. Steps for your reference: Create a DNS host record using your company name and map it to your SharePoint server. Binding the DNS host record ...
user avatar
  • 2,879
2 votes
Accepted

PWA SiteCollection in WebApplication root

Yes, we could select the Project Site template as the root site of the newly created web application:
user avatar
  • 4,002
2 votes
Accepted

Content database size discrepancy/inconsistency - why?

Do you have blob storage configured by any chance? It might explain why your MDF file is smaller on disk. db.DiskSizeRequired shows how large is database in terms of consumed spaced. This should ...
user avatar
2 votes
Accepted

SharePoint 2019 on premise - user profiles not deleting from search

This is expected behavior when using AD Import. AD Import will not automatically do anything to a profile that no longer falls into the scope of the import (e.g. if you begin filtering which would ...
user avatar
  • 4,002
2 votes
Accepted

SharePoint Powershell creating a dynamic view with [Me] filter

Please run the below PowerShell script as an admin on SharePoint Online Management Shell: #Config Variables $SiteURL = "https://{domain}.sharepoint.com/sites/{sitename}" $ListName= "{...
user avatar
  • 2,687
2 votes
Accepted

Enable users edit permission only for items added by him in a list

There is an option under the advanced properties of a list that I think does exactly what you want. Just click the 3 dots next to a list in your site contents, click Settings and click Advanced ...
user avatar
2 votes
Accepted

Add file to document library, title not getting updated

This blog post appears to answer your question: Set Title Field on Document Upload
user avatar
  • 11.5k
2 votes

How to detect enabled QuickEdit on a List or Library from client?

You can get the Quick Edit property value of list using SharePoint REST API. For all lists on the site: https://tenant.sharepoint.com/sites/siteName/_api/web/lists?$select=Title,DisableGridEditing ...
user avatar
  • 28.2k
2 votes

Injecting CSS on SharePoint Modern pages in SharePoint Server 2019 environment

The web part in the link you provided is using SPFx v1.8.0 which is supported in SharePoint online only. While SharePoint 2019 supports SPFx version up to v1.4.1 only. Source: SharePoint Framework ...
user avatar
  • 28.2k
2 votes

SharePoint Workflows 2010 & 2013 in SharePoint 2019 on-premise after year of 2026

The "no longer supported" notion from Microsoft means that Microsoft won't support the product after the end date. That means that you can't ask Microsoft for support, but it doesn't mean ...
user avatar
  • 25.4k
1 vote

Granting AnonymousSearchAccessList permission to users in SharePoint 2013

The "AnonymousSearchAccessList" permission cannot be displayed in the list of available permissions, which requires additional configuration by the administrator. Please following steps: ...
user avatar
  • 2,687
1 vote

Calculated column difference between two dates considering Today

Your formula seems incorrect. If you notice the difference in dates 9/1/2021 - 9/21/2021 = -20 but your screenshot is showing -19. Try using this formula below =IF(InductionCallDate>TodayDt,...
user avatar
  • 455
1 vote

Do I need to install Updates from September 2020 individually or I can directly install July 2021

You can directly install the latest July 2021 updates. As per my understanding all new updates are backward compatible with older updates.
user avatar
  • 28.2k
1 vote
Accepted

Sharepoint 2013 domain migration - no trust

It is a very typical situation. AI's blog have described the commands and preparation you need to convert domainA users to domainB users. In short, after you mounted the old content DB to domainB, ...
user avatar
  • 4,016
1 vote
Accepted

DATEDIF function returning wrong number of days

Select Number under The data type returned from this formula is: option in column settings. Reference: DATEDIF function
user avatar
  • 28.2k
1 vote

SharePoint calculated column based on other 2 columns

Try using this: =IF(OR(ISBLANK([Infected]); ISBLANK([Vaccination date])); ""; IF([Infected] = "Yes"; [Vaccination date] + 14; "")) Documentation: Calculated Field ...
user avatar
  • 28.2k
1 vote

Batch update task field In SharePoint Project server 2013 using CSOM

I've figured it out. The issue was that the biundary in my request differs from the batch number. Still doesn't work though, but now I get response: --batchresponse_a97eef74-38b3-4c1d-b082-...
user avatar
1 vote

SharePoint Server Subscription Edition Upgrade

It seems that we can move a 2016 Database directly to the SharePoint Subscription Edition. Not quite sure why it is possible, but my best guess is that the SP Subscription Edition is barely any ...
user avatar
1 vote
Accepted

Group Permissions in SharePoint 2013

Please run the below powershell script as an admin: if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null) { Add-PSSnapin "Microsoft....
user avatar
  • 2,687
1 vote
Accepted

Promoted Links to Network File Share Path Not Working

That's a known issue in SP 2019. This issue can be reproduced in both SP2019 and SP Online. In SP 2016, it does not work in another way. I would suggest you pay attention to the updates released in ...
user avatar
1 vote
Accepted

Migrating an Application Server to another newly-introduced Server to the Farm

I have done this with 2010. We transitioned from 08r2 to 2012r2 All you have to do is add the new servers to the farm. Change your DNS entries to the new web server IP. And then remove the old ...
user avatar
  • 1,389
1 vote

Uncaught TypeError: Cannot read property 'isNullOrUndefined' of undefined from sp.core.js

Adding the below scripts to the page fixed the issue. <script type="text/javascript" src="_layouts/15/sp.runtime.js"></script> <script type="text/javascript&...
user avatar
1 vote

HELP SharePoint 2016 farm is completely down

Have you checked the event-log on the server? Service account password changed? Use PowerShell to get the most relevant events. Merge-SPLogFile -Path "C:\tmp\FarmMergedLog.log" -Level High
user avatar
  • 51
1 vote

HELP SharePoint 2016 farm is completely down

Without much details I cannot say what went wrong. You can try below: Check the DNS and Load Balancer configuration Check if the SharePoint Timer Service is started Verify that the SharePoint Servers ...
user avatar
1 vote

Show Attachment File Names in a List View

Download JQuery Api and upload js file to Site Assets library. Save the below code as JS file and upload it to Site Assets library. (function () { // Create object that have the context information ...
user avatar
1 vote
Accepted

Unable to alter new item entry form in SharePoint 2019 modern experience

This feature is available on SharePoint Online, but not available in SharePoint server 2019: More information for your reference: https://docs.microsoft.com/en-us/sharepoint/dev/declarative-...
user avatar
  • 4,002
1 vote
Accepted

IF statements SharePoint 2003

If [RAG] column is of type Number, try using this: =IF([RAG] <= 3, "Green", IF(OR([RAG] = 4, [RAG] = 5, [RAG] = 6), "Yellow", IF(OR([RAG] = 8, [RAG] = 9, [RAG] = 10), "...
user avatar
  • 28.2k
1 vote

Unable to create Publishing site or unable to activate publishing feature on SharePoint 2019

Please go to the root folder get denied in your error message, right-click and security tab. Provided network service to set read and write permission to the root folder.
user avatar
  • 4,002
1 vote

How to prevent SharePoint site page refresh itself when jquery .load is triggered?

As per my understanding (Correct me if I am wrong), you forgot to add the type="button" to your button element. So, Add type="button" to the button element like: <button type=&...
user avatar
  • 28.2k

Only top scored, non community-wiki answers of a minimum length are eligible