In classic list views/forms and on-premise environments, your choice columns allow you let users specify their own value. But the label is literally “Specify your own value:”. This can be changed. Note: If you’re using the modern experience, you don’t have this issue. To change the label, add the following script to your newform.aspx page, […]
Date and time fields can have a default value of “Today” or “Now” that populates if you don’t enter another value in the field before saving an item. In your date/time column settings: If you choose type “Date only” you’ll get the current date If you choose “Date and time” you’ll get the current date […]
I previously shared how to create a “Today” column in SharePoint that would always be up-to-date even if list items weren’t modified. These were no-code solutions that utilized either SharePoint Designer or Microsoft Flow. You can, however, use Today’s date/time to create views and calculated columns without workflow or script or the need to create […]
Since we can’t have an always-updated Today column OOTB, use Microsoft Flow to update a date column daily for use as a “Today” column in calculations.
This post goes through how we can get our lookup columns to render as text in separate columns so that we can use those values for various purposes.
Compare two dates in a calculation to get a result in years, weeks, days, hours or minutes. Use rounddown, roundup, concatenate and isblank to clean up your data.
Learn to create a Today column partnered with SharePoint Designer workflow to always provide today’s date. This solution is essential to creating other calculated columns for things such as “Years of Service”.
Add a calculated column to your calendar that generates a clickable hyperlink to an .ics (or iCal) file that allows you to add the calendar item to your own calendar.
Change SharePoint list column widths to be custom-sized and responsive.
Remove select/de-select checkmark column, column headers, edit/new options, and border in SharePoint list view web parts